ExcelBanter - Replicate right from A2,A3,A4 TO B1,B2,B3 etcetera

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Replicate right from A2,A3,A4 TO B1,B2,B3 etcetera (https://www.excelbanter.com/excel-worksheet-functions/9677-replicate-right-a2-a3-a4-b1-b2-b3-etcetera.html)

Juice Man

Replicate right from A2,A3,A4 TO B1,B2,B3 etcetera

How?

Juice Man

Jason Morin

Place this in B1 and fill across:

=OFFSET($A$2,COLUMN()-2,)

HTH
Jason
Atlanta, GA

-----Original Message-----
How?

Juice Man

.

Arvi Laanemets

Hi

Into B1 enter the formula
=IF(A2="","",A2)
and copy down

Arvi Laanemets

"Juice Man" wrote in message
...
How?

Juice Man

Ola

If it's headlines:
A2:A10 right click Copy
B1 right click Paste Special Transpose

Done!
Ola

Myrna Larson

On Sun, 23 Jan 2005 22:51:33 +0200, "Arvi Laanemets"
wrote:

Into B1 enter the formula
=IF(A2="","",A2)

That looks to me like it's going to give exactly the same results as =A2. What
am I missing?

Dave Peterson

If a2 is empty, then =a2 will return a 0???

Myrna Larson wrote:

On Sun, 23 Jan 2005 22:51:33 +0200, "Arvi Laanemets"
wrote:

Into B1 enter the formula
=IF(A2="","",A2)

That looks to me like it's going to give exactly the same results as =A2. What
am I missing?

--

Dave Peterson

All times are GMT +1. The time now is 04:34 AM.