MATCH Function in Excel एक्सेल में मैच फंक्शन का प्रयोग With the help of match function we find out position of a lookup value in a row or column. It does not return the value. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. We often use match with Index and Vlookup for getting data. It can be used with text and numbers. This function looks for an item in a list and shows its position. […]
Read moreI have to extract first name from a cell in excel. हमें एक्सेल में एक cell से first नाम निकलना है. Here we have only one logic that from start to end, what is the position of first space in cell, we have deduct 1 in that position, then from left side we will pick number character with help of left function to extract first name. यहाँ हमें […]
Read moreEDATE With the use of Excel EDATE function, we add or subtract month, with a date. We use EDATE function to calculate Maturity Dates, Expiration Dates, Due Dates, Project Start Date, Project End Date. If we use month value as positive, then it will go future date, if we use month value as negative then it will go past date, if we use month value 0 then it will show same date. Here only month & year will be […]
Read moreSUMIF 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 moreDear All, From this video you can learn how to extract last word from a Cell in Excel.
Read moreDear All, From this video you can learn how to extract last word from a Cell in Excel.
Read more