Took me less than a minute to drag down the formulae! So for me wasn't difficult at all!
Took me less than a minute to drag down the formulae! So for me wasn't difficult at all!
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.
Thanks for your immediate response. The file I uploaded was only a sample. My actual file has more 10,000 rows and it is not easy to drag or copy for 10,000 rows. Also, this requirement has to be implemented repeatedly for multiple projects. So the best would be a formula which can calculate unique text values with multiple criteria.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks