help

  • Thread starter Thread starter tommyboy
  • Start date Start date
T

tommyboy

I have a worksheet which updates a list every min onto a timesheet,

Instead of having every minuit i want it just to show the period

I want this

2 AUX 9:39
2 AUX 9:40
2 AUXOUT 9:41
2 AUXOUT 9:42
2 AUXOUT 9:43
2 AUXOUT 9:44
2 AUXOUT 9:45
2 AUXOUT 9:46
2 AUXOUT 9:46
2 AUXOUT 9:47
2 AUXOUT 9:48
2 AUXOUT 9:49
2 AUXOUT 9:50
2 AUXOUT 9:51
2 AUX 9:52
2 AUX 9:53
2 AUX 9:54
2 AUX 9:55
2 AUX 9:56
2 AUX 9:57
2 AUX 9:58
2 AUX 9:59
2 AUX 10:00
AUX 10:01


To look like

2 AUX 9:40
2 AUXOUT 9:51
2 AUX 10:01

any help,






What i want is to If A2 = A1 then d
 
I'm guessing that you have 3 columns (2, Aux*, time). And that the last 2 was
dropped by mistake in the post.

I'd put this formula in D1 and drag down:

=IF(B1=B2,"Delete","keep")

The apply Data|filter|autofilter and filter to show deletes. then delete that
visible range.

then data|filter|autofilter (to remove the filter) and delete column D.

It looks like you're just keeping the last one in the "group".
 
how does this give me the list in the view i want

it just tells me if it is a duplicate or no
 
"Then apply Data|filter|autofilter and filter to show deletes. then delete
that
visible range.
then data|filter|autofilter (to remove the filter) and delete column D."

if you have bothered to read Dave's first message



Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top