need If or Transpose formula

[basavarajkh]

Hi

I had used the countif formula in sheet!1 i.e., =COUNTIF(A2:A1048576,"R")& draged from cell A1 to J1.

& I want that same result in sheet! 2 in transpose mode (i.e. in sheet!2 cell A1 to A10). Which formula can I write. Plz help me to write


Thanks


Regards

Basavaraj K H

 

[Hui]

Basavaraj


This is one of my favorite Excel tricks


On Sheet1 Select A1:J1

Ctrl H (Find & Replace)

Find What: =

Replace with: #=

Apply

With A1:J1 still selected

Ctrl C (Copy)


Change to Sheet2 A1

Paste Special, Transpose

Ctrl H (Find & Replace)

Find What: #=

Replace with: =

Apply


Now on Sheet2 with A1:A10 still selected

2 more replacements


Ctrl H (Find & Replace)

Find What: (

Replace with: (Sheet1!

Apply


Ctrl H (Find & Replace)

Find What: :

Replace with: :Sheet1!

Apply


I think that's what your after

 

[Montrey]

use =transpose(


This is an array formula so make sure you enter with Ctrl+shift+enter