Assuming the excel got header and the duplicate rows are in first column: =IF(COUNTIF(A$1:A1,A2)>0,A2 & "." & COUNTIF(A...
Showing posts with label Excel Tutorials. Show all posts
Showing posts with label Excel Tutorials. Show all posts
Tuesday, January 5, 2021
Monday, May 18, 2020
Sometime we might be needed two columns to match and take the third column values. Confused? OK let me tell you a scenario. Suppose i ha...
Monday, May 11, 2020
Sometimes we need to match two columns to see if a term in Column A is there in Column B. In such cases COUNTIF function will be handy. T...
Tuesday, July 30, 2013
Its very easy to convert excel data into lower and upper cases. For changing into lowercase, use formula ...
Tuesday, July 23, 2013
Combining two or more column in an excel can simply done using the formula =concatenate(a1,b1) .......................................
Sometime our data contain unwanted leading and trailing spaces in excel. But dont be panic. Removing it is very simple. Yuo can use formula...
Monday, July 8, 2013
Sometimes we need to put alternate empty rows in an excel. For this just copy below code and run macro.You are done. Sub InsertAlt...
Friday, June 21, 2013
Sometimes we need to put empty rows in excel for every change in id/values in a column. Below macro helps us to put empty rows for every c...
