hello to all
I have data in different columns and i want unique record for each column at the same location. Excel file is attached for you review.
thanks in advance
hello to all
I have data in different columns and i want unique record for each column at the same location. Excel file is attached for you review.
thanks in advance
Can more explain more?
Unique Record base on combination of GL Code&Name, or random generate number and character?
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
In F3 and copy down this ARRAY formula.
=IFERROR(INDEX(List;MATCH(0;COUNTIF(F2:$F$2;List)+(COUNTIF(List;List)<>1);0));"")
In G3 and copy down, this one..
=IFERROR(INDEX($B$3:$B$20;MATCH(F3;List;0));"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
First i want unqiue record of on basis of column "A" and then extract unique record on the basis of column "B" .
GL Code 44 and name "B" should also be hide.
Why? There is only one 44 in column A!
Sorry could not explain properly. i want unique record for each column individually. First i want unique record in column A and then remainming data in both column i want unqiue record on the baisi of column B
OK. Probably i am the one that i don't understand..So let's take these 1 by 1..
.Can you explain us why the result for column A is not correct?..for each column individually
Data Base
GL Code Name
11 A
22 B
33 C
11 D
44 B
55 F
22 G
66 H
Step 1
GL code name
33 C
44 B
55 C
66 H
Step 2
33 C
44 B
66 H
the above information is not correct plz now follow the instructions
data base
GL Code Name
11 A
22 B
33 C
11 D
44 B
55 C
22 G
66 H
Step-1
GL Code Name
11 A
22 B
33 C
44 B
55 C
66 H
Step 2
Final Requirement
DATA
GL Code Name
11 A
22 B
33 C
66 H
plz consider the second reply
the above information is not correct plz now follow the instructions
data base
GL Code Name
11 A
22 B
33 C
11 D
44 B
55 C
22 G
66 H
Step-1
GL Code Name
11 A
22 B
33 C
44 B
55 C
66 H
Step 2
Final Requirement
DATA
GL Code Name
11 A
22 B
33 C
66 H
You change the goalpost every time that you post...
Sorry to bother u again & again. thanks for all ur help. solution is as per my requirement. can u do the same procedure through filters bcoz I want to make analysis on the same location if it is possible plz do let me know.
this can be done through adv filter option(unique record)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks