Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search cell value in same column
I have a huge excel sheet where i need to find the address of duplicate cell value in a column.
I have given an example below, where Column B returns the address of duplicate value found in Column A. Could you please help by providing the formula for Column B result? VBA is also fine. | A | B 1 | Apple | A4 2 | Orange | A6 3 | Mango | no-match 4 | Apple | A1 5 | Grapes | no-match 6 | Orange | A2 7 | Pineapple | no-match I used the formula "=ADDRESS(MATCH(A1,(($A$1:$A$7)),0)+ROW($A$1)-1,COLUMN($A$1:$A$7),4)", which returned the cell address of same cell that is being searched. Apple | A1 Orange | A2 Mango | A3 Apple | A1 Grapes | A5 Orange | A2 Pineapple | A7 I did enough search over internet, but could not find. In the above formula, I just need to ignore searching for the cell being searched. Please help. Last edited by mdIsmailkm : November 2nd 13 at 07:29 AM Reason: Format of the table provided is not appropriate. it removed more spaces with one space |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search the column and return a cell value | Excel Programming | |||
Search for first empty cell in column | Excel Programming | |||
SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW | Excel Worksheet Functions | |||
Loop through column headers to search from column name and get cell range | Excel Programming | |||
search column for specific cell using vba | Excel Programming |