Hide following numbers

miltdp

Posts: n/a

Thanks JE, as much as I've struggled with that it looks too simple but it
usually is. I'm sure this will do the job

"JE McGimpsey" wrote:

One way:

J2: =IF(I2="","",I2)
J3: =IF(I3="","",J2-I3)

Copy J3 down to J31

In article ,
miltdp wrote:

Is there a formula or way to keep the rest of the column (j4:J31) blank until
there is some activity in the spent.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Checking Winning Numbers in the Lottery.	Ann	Excel Discussion (Misc queries)	4	May 18th 05 10:55 AM
Match Last Occurrence of two numbers and Return Date	Sam via OfficeKB.com	Excel Worksheet Functions	6	April 5th 05 12:40 PM
Match Last Occurrence of two numbers and Count to Previous Occurence	Sam via OfficeKB.com	Excel Worksheet Functions	33	April 4th 05 02:17 PM
Count and Sum Total occurrances of two specific numbers	Sam via OfficeKB.com	Excel Worksheet Functions	10	March 29th 05 08:13 PM
Converting Numbers to Text properly	Shirley Munro	Excel Discussion (Misc queries)	1	February 16th 05 03:01 PM

All times are GMT +1. The time now is 09:52 AM.

Menu

About Us