Nick Sabo

Junior Member

Posts: 5

Quote:

Originally Posted by plinius

In Y4 put:
=MAX(--SUBSTITUTE(SUBSTITUTE(C4:L4,"<",""),"-",0))
(matricial formula, to confirm by CTRL+SHIFT+RETURN)

Wow, didn't know about SUBSTITUTE(), that's really useful. However, it still seems not be working, somehow... does it work for you?

EDIT: Wow I didn't know about CSE Formulas. That is staggeringly useful and completely unintuitive, but thank you, you're amazing!

Last edited by Nick Sabo : September 17th 12 at 11:52 PM

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
Multiple Functions of a Cell	Drew	Excel Worksheet Functions	3	June 2nd 09 07:43 PM
multiple functions on one cell ?	Tim R	Excel Discussion (Misc queries)	6	October 24th 07 09:40 AM
efficiency: database functions vs. math functions vs. array formula	nickname	Excel Discussion (Misc queries)	2	July 14th 06 04:26 AM
MUltiple functions on a same cell	harshaputhraya	Excel Discussion (Misc queries)	1	May 8th 06 06:28 AM
Multiple functions per cell?	excelnewbie	Excel Worksheet Functions	6	September 19th 05 09:33 AM

All times are GMT +1. The time now is 07:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us