Hi Gurus, I have below queries in the sheet I have attached
1. The cells were pasted with Special Paste BY VALUES which were calculated by the formula and had no values returned. They appear blank and are not really blank.
They show counts when only blank cells are selected.
I want to clear all the contents of these BLANK LOOKING cells in the array to enable correct counting of the blanks and the ones with the values. I HAVE FOUND A FIX FOR THIS WITH CTRL+F and Selecting "match Entire Cell Contents" does a fantastic job.
2. In the Sheet, I have Vendors in the First Column and have many Entries with Values as determined by formula and blanks cells in between. Can I get these Row
Entries serially by ignoring blanks? (As shown in the "Required" Sheet
Thanks in advance