Hi everyone.
I have a data entry range running from C6:AD2506.
In cell A6 i want it to say "Item." is cells C6:AD6 are all blank and just "Item" if there is any data entered on that row (wihtihn my range).
Should I compare C6:AD6 to a blank row at the bottom of the page for this? or .......
Well, how should I do it. Also where in the formula do I have to put the $$$$ marks?
Try
=IF(COUNTA(C6:AD6)=0,"Item","")
Can you post in the correct forum, this should be in the Functions forum.
Last edited by royUK; 07-16-2008 at 06:29 AM.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
oops sorry.
that worked perfectly btw..thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks