Empty Cell not empty

  • Thread starter Thread starter Phillip Topping
  • Start date Start date
P

Phillip Topping

If I use the following formula:

=IF(B25="","",B25+C25) in Column U all the way down
to Row 20000

to create a new value...

(Column B has a date and Column C has a Time) and then
copy and paste Column U to Column T as values, I see empty
cells in Column T once my data runs out (presently around
Row 40.

However....if I use the CountA function,it is telling me
that I have data in Column T all the way down to Row 20000.

Since this combined Date/Time is being used as X Axis data
it is screwing up the graph because Excel thinks those
cells are Jan 1, 1900 when in fact they are supposed to
be "nothing".

How can I change the original formula to prevent this or
how can I identify and find the character in Column T and
delete it.

I know I can easily just highlight the range and delete
it...but I need to put it in a macro as the number of data
points will vary over time.

TIA
Phillip
 
If your fake empty cells will appear only at the end of the data set,
you can use something like =COUNTA(A1:A8)-COUNTIF(A1:A8,"").

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top