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 […]
Recent Comments