Category Excel

Compare two columns and color highlight cell differences in Excel

I have two column in excel like below A        B 100  100 200  600 300  700 400  800 500  900 I want a result like below Ans: In MS Excel,use below steps 1.Tools > Macro > Visual Basic Editor. 2.Select the sheet. 3.Insert > Module. 4. Sub compare_cols()     ‘Get the last row     Dim […]

get comma separated string from excel 2003

I have created a module in Excel 2003. 1.Tools > Macro > Visual Basic Editor. 2.Select the sheet. 3.Insert > Module. 4. Function csvRange(myRange As Range) Dim csvRangeOutput For Each entry In myRange csvRangeOutput = csvRangeOutput & “‘ ” & entry.Value & “‘, ” Next csvRange = csvRangeOutput End Function Then call using =csvRange(A1:A10) It […]