Hi all,
Again basic question.
I have sheet1.
In there column 1 I have data .
This data is sagrigated to remove duplicates to make a list.
This list is copied in sheet2.
Here I want to include formula in column 2 of sheet2, to vlookup list in column 1 in sheet 2 and counta from sheet1 column 1 how many times that entry is made .
Hopefully it will be a formula.
Need some help please
Kind regards
Hello
Do you mean in B1 and copy down this?
Formula:
Please Login or Register to view this content.
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.
Hi Fotis1991,
Thanks. It works great.
Simple but very effective solution.
Many thanks
Kind regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks