Posted to microsoft.public.excel.programming

diesel

external usenet poster

Posts: 3

connecting two cellswith out changing either of them

I am trying to find a way to connect two cells together when one is text and
the other is numbers so when i am looking for the largest number in a string
of cells the two connected cells are placed in the answer cell ie:
{B3:I3=text and B36:I36=numbers}
In the answer cell D40 the largest = either B3/B36 or C3/I36 and so on ?
Hope this isn't too confusing

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
Connecting to FTP	ben	Excel Programming	1	April 20th 06 05:12 PM
Connecting Modules in VBA	Jenny	Excel Programming	8	November 16th 05 08:36 AM
Connecting to SQL from Excel	Keith La Force	Excel Programming	4	March 2nd 05 09:27 PM
Need Help Connecting To DB	J.Adams	Excel Programming	3	May 31st 04 06:34 PM
Connecting to a DB in VBA	Tom S[_3_]	Excel Programming	1	January 16th 04 02:44 PM

All times are GMT +1. The time now is 11:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us