Posted to microsoft.public.excel.worksheet.functions

Bondi

Posts: n/a

how to get last two rows??

Hi,

There is proberly an easier way to do it but you can use CountIf() and
Ofsett(),
Asuming your data for May 2004 is en cell B3 this should give you the
pct change

=(OFFSET(B3,COUNTIF(B3:B6,"0")-1,0)-(OFFSET(B3,COUNTIF(B3:B6,"0")-2,0)))/(OFFSET(B3,COUNTIF(B3:B6,"0")-2,0))

The difference can be calculated with the same functions:

=(OFFSET(B3,COUNTIF(B3:B6,"0")-1,0))-(OFFSET(B3,COUNTIF(B3:B6,"0")-2,0))

Best regards
Bondi

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
Rows & Columns in Excel	seadragon69	Excel Worksheet Functions	2	December 7th 05 05:54 PM
Automatically inserting rows	ausdiver99	Excel Worksheet Functions	1	June 2nd 05 02:15 PM
Hiding Rows if the linked rows are blank	KG	Excel Discussion (Misc queries)	9	May 18th 05 02:32 AM
Insert rows	Mr. G.	Excel Worksheet Functions	3	March 31st 05 03:49 AM
flexible paste rows function that inserts the right number of rows	marika1981	Excel Discussion (Misc queries)	1	February 18th 05 02:40 AM

All times are GMT +1. The time now is 05:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us