Letters to a graph or formula?

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Hi All.

I have a sheet that has the status of boats, for a month.
My guys enter B0, B6, C, etc. Can I take this data and
make a formula or a graph indicating how many days for
the month it was in a particular status. ie. B0,
divided by 30 for example. I can only do this using
numbers and wondered if there was a way.

Thanks a million.
 
Hi
use COUNTIF to count the number of occurences and use this as basis
four your chart. e.g.
=COUNTIF(A1:A100,"B0")
 
You are the man Frank, thanks!

Quick question and I hope this doesn't need to be in a
New Post, but I am entering the B0, B6, C, etc data as
mentioned earlier, on one sheet, and then I have to go RE-
ENTER it on another for this feature you just helped me
with. I could not have the first updated AUTOMATICALLY
update the second sheet. I tried Paste Link, but it
would update the whole ROW. In other words, I need to be
able to update one page, and based upon the date, have it
automatically place that days status on page 2 in the
proper date column. Is this even possible?

Thanks again!
 
Hi
could you post some example rows of your data sheet (plain text - no
attachment please) and also your expected result as I'm not so sure
what your expected result is?
 
Thanks,
Page one:

47255 B0 47259 B0
220521 B0 41417 B0
25413 B0 210599 B0

and on Page 2:
July
Unit 01 02 03 04 05 06 07
47255 B0 B0 B0 B0 B0 B0 B0
220521 B0 B0 B0 B0 B0 B0 B0

Whereas, the data entered on page one (in this case B0),
automatically be entered as the same, on the appropriate
(todays) date on page 2.

Thanks in advance!
Scott
 
Hi Scott
and how do you know which is the correct date on the second page as on
the first sheet no data information is stored?
 
True, but I do have the date on the first page, I have
the =TODAY() in a cell near the top. Can that be used to
help enter the data on page 2 in the correct area?

I appreciate the help.
Scott
 
Hi Bob
this probably won't work as this date changes every day and the
formulas would update. Maybe you can describe how you enter the data.
Best would be if you add a datestamp after each record in a separate
date column
 
I made a drop-down validation in the cell on page 1,
thats how we enter it.

You got me thinking though, could I add a column after
it, and use the =TODAY() function, and then hide the
column but still use the date function??

Thanks again,
Scott
 
Hi
problem with this approach is that also this column would change
automatically. if you want to insert a datestamp automatically ou'll
need VBA.
 
I think I will stick with what I have got for now.
Thanks again for ALL your help Frank.

Scott
 
Back
Top