Posted to microsoft.public.excel.misc

Sushil[_3_] Sushil[_3_] is offline

external usenet poster

Posts: 1

Formula to explain

Can any one please explain this:

=SUM(MID(0&D19,LARGE(IF(ISNUMBER(MID(0&D19,ROW($1: $256),
1)*1),ROW($1:$256),1),ROW($1:$256)),1)*1)*10^(ROW( $1:$256)-1)

Though it was put in and explained by my manager, but I don't
remember.

Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Please explain a formula	Miss Mattax	Excel Discussion (Misc queries)	6	March 3rd 09 08:32 PM
Please explain this formula	Iriemon	Excel Worksheet Functions	2	February 3rd 09 12:54 AM
Please explain formula to me	Paul	Excel Worksheet Functions	2	December 10th 06 02:57 AM
Could any one Explain this Formula	John	Excel Worksheet Functions	8	April 22nd 06 07:15 PM
Please Explain Formula	Karen	Excel Worksheet Functions	4	June 16th 05 11:46 PM

All times are GMT +1. The time now is 02:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us