SUMIF Function in Excel

SUMIF   With the help of SUMIF Function in excel we get total value of all numbers in a range of cells based on one criteria. SUMIF की मदद से हम एक्सेल में, किसी range में से एक criteria के base पर, नंबर का टोटल निकलते है. For example in below image, we have item name & their value. उदाहरण के लिए, निचे के image में, item का नाम और valueहै. I want to sum of all value which is […]

Read more

Use of Eomonth Function In Excel

EOMONTH   With the help of EOMONTH Function in excel, we determine the date of the last day of the month. It can be future or past date. We have to specify number of months before or after for this date. If use use eomonth(date,0), then it will return last day of date, which has given by us. If we use eomonth(date,2), positive number as month then it will go 2 months ahead and will return last date of that […]

Read more

Use of Right Function in Excel VBA Macro

RIGHT We can use RIGHT function in excel & macro both. With the help of right function we extract characters from right site of a cell value or string. हम Right Function का प्रयोग Excel & Macro दोनों में करते हैं. Right Function की मदद से हम किसी Cell की वैल्यू से Right side  से characters निकाल सकते है.   We have Computer value in Cell A1. We use Right(Range(“A1”).Value, 3) to pick 3 character from right side of A1 cell […]

Read more

Use of Left Function in Excel VBA Macro

LEFT We can use left function in excel & macro both. With the help of left function we extract characters from left site of a cell value or string. हम Left Function का प्रयोग Excel & Macro दोनों में करते हैं. Left Function की मदद से हम किसी Cell की वैल्यू से Left side  से characters निकाल सकते है.   We have Computer value in Cell A1. We use Left(Range(“A1”).Value, 3) to pick 3 character from left side of A1 cell […]

Read more