Monthly Archives: May 2013

Compare two columns and color highlight cell differences in Excel

May 23, 2013 · by · in Excel · Leave a comment

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

May 22, 2013 · by · in Excel · Leave a comment

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

How to select the first row of each group in Oracle?

May 1, 2013 · by · in ORACLE, SQL SERVER · Leave a comment

I have a table like this: ID | VAL | DATE ———————- 1 | 10 | 25/12/2013 1 | 2000 | 25/12/2012 2 | 5 | 25/12/2012 2 | 3 | 25/12/2013 I want to make a SELECT that will return just the first row for each ID, ordering by Date. Sample output: ID | […]