Sorry I'm an excel noob, I don't understand what to do.
On a side note though, i was wondering what the formula would be if it was
just to find whether Cells(1, 1).Value exists in row B, and where it would
be. Also what would the formula for selecting the bottom row with a value
in it be?
Hi
You need to use count if formula to get what you want..in range you need to
specify both the column where probable value would be.
Refer file in my previous post with yellow colored range.
Cheers!!
On Sun, Jun 15, 2014 at 12:02 PM, Noah Shalii koukinom...@gmail.com wrote:
Sorry I'm an
Hi, thanks for the help.
However, this only seems to work with the set of values I provided as an
example.
i was wondering if there is a way it would work with any set of numbers I
add to the A column.
Thanks
On Sunday, June 15, 2014 2:09:39 AM UTC+9, Noah Shalii wrote:
Hi, I am in need of
Hi
Check yellow cells..
Cheers!!
On Sun, Jun 15, 2014 at 11:05 AM, Noah Shalii koukinom...@gmail.com wrote:
Hi, thanks for the help.
However, this only seems to work with the set of values I provided as an
example.
i was wondering if there is a way it would work with any set of numbers I