use several cells from differnt areas as one row (or column)

**miro_ilias** · 02-26-2013, 02:57 AM

Dear experts,

let us have several cells from different areas containing numbers. I would like to use these numbers as in one row (or column).

Example: A3 B3 and C4 are filled with numbers. It there a quick command line formula to view these cells are beeing in one row (or column) ?

Many thanks, Miro

**visha_1984** · 02-26-2013, 03:04 AM

Tri this in

D4

Please Login or Register  to view this content.

CLICK the STAR icon on the left side below their user name to say thank you to those who had helped you.

**abubaniyan** · 02-26-2013, 03:44 AM

hi,
use the combination of "concatenate" and "isnumber" formula....

if not been able to do the same then upload the file...!

**miro_ilias** · 02-26-2013, 04:56 AM

Hi friends,

I still can not get delocalized numbers into one row... see the attached file (MS Excel 2010).

Miro

**abubaniyan** · 02-26-2013, 05:29 AM

try this....!

**miro_ilias** · 02-26-2013, 05:41 AM

Hi,

thanks for the post, but I would need to keep the order of cells - A3,B3,C4 - in a one-row(column) formula. The proposed SMALL function in zour example sorts the cell values, and this not wanted...

**Marcol** · 02-26-2013, 06:13 AM

Not sure what you are trying to do, a sample of your actual workbook would help.

See if this workbook helps you.

**miro_ilias** · 02-26-2013, 09:00 AM

Hi Marcol,

thanks for your formula suggestion which works;

the idea is to "straigten" broken row (which is splitted over 2 areas) into one compact row (see fresh attachement);

BTW, isn't there a way to simplify formulas of these types ?

=IF(COLUMNS($B:D)>COUNT($B16:$C16;$D15:$E15);"";MID(SUBSTITUTE(" "&$B16&" "&$C16&" "&$D15&" "&$E15;" ";REPT(" ";255));255*COLUMNS($B:D);255)*1)

Best, Miro

**Marcol** · 02-26-2013, 10:54 AM

I'm still not sure as to what you are trying to do.

If any column can only have one value, then you could add the two, or more ranges to get a single array, or simply sum the columnns.

See this workbook.

use several cells from differnt areas as one row (or column)

LinkBack

Thread Tools

Rate This Thread

Display

use several cells from differnt areas as one row (or column)

Re: use several cells from differnt areas as one row (or column)

Re: use several cells from differnt areas as one row (or column)

Re: use several cells from differnt areas as one row (or column)

Re: use several cells from differnt areas as one row (or column)

Re: use several cells from differnt areas as one row (or column)

Re: use several cells from differnt areas as one row (or column)

Re: use several cells from differnt areas as one row (or column)

Re: use several cells from differnt areas as one row (or column)

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions