Hi,
I am trying to use a formula which first creates a unique list based on the names in column C and then use a simple countif formula to count the number of occurrences.
I have it working for the list however the problem is when I have blank rows.
On my attached file, cells W38:X61 is where I have the list. Can anyone see what I am doing wrong? I wouldn’t want the cells in yellow to be included as the list is to be graphed.
Paul
May be this...
In X39 Cell
Formula:
Please Login or Register to view this content.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi,
That worked for the Count column thanks!
Is there anyway to remove the "0" from the unique list of names (cell W44)?
Try in W39 and copy down, this regular(not ARRAY) formula.
=LOOKUP(REPT("Z",5),CHOOSE({1\2},"",INDEX(List,MATCH(TRUE,INDEX(ISNA(MATCH(List,W$38:W38,0)),0),0),1)))
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 Fortis - this formula contains an error (it doesnt like this part "{1\2}")
Strange..Paul. What do you see in my attachment?
Strange - the file you provided worked!
Can you help with graphing the list? The problem I am experiencing is that it doesn’t like the rows which do not contain data.
I have googled the problem and I need it to ignore blank cells however because they contain formula they are not blank.
If I select the chart range W38:X43 the chart works as this contains data. However if I select the range W38:X61 it doesn’t work. I would need to use this as the range as the list would be dynamic.
I have re-uploaded the file with the working formulas.
I have no idea..I don't work with graphs, so i don't know much for these..
I just modified your List(in column C) to be dynamic..but i see nothing different. Sorry..
Ok, thanks Fortis. I will mark this post as solved
.......................
. Fo(r)tis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks