how to insert same row numbers in several function statement

I

iksuinje

Hi,

I am doing data processing without using macro...because data formats are so
random.

My qustion is about how to insert same row numbers in the several function
statement even though the colums are different. My function statements are as
follows. They are all used in one sheet.
IF(E3="","",COUNTIF(D$3:D$306,LEFT(D3,FIND("/",D3)-1)&"*"))
IF(E3="","",COUNTIF('[example.xls]variables to 2004'!$E$3:$N$306,E3&"/*"))
IF(E3="","",COUNTIF('[example.xls]variables to 2004'!$E$3:$L$306,E3&"/*"))
IF(E3="","",COUNTIF('[example.xls]variables to 2004'!$E$3:$J$306,E3&"/*"))
IF(L3="","",COUNTIF(K$3:K$306,LEFT(K3,FIND("/",K3)-1)&"*"))
IF(L3="","",COUNTIF('[example.xls]variables to 2004'!$G$3:$P$306,L3&"/*"))
IF(L3="","",COUNTIF('[example.xls]variables to 2004'!$G$3:$N$306,L3&"/*"))
..
..
..

As you see the same row numbers "3" and "306" are frequently used. So is
there any way to simply insert this numbers only once then let it
automatically inserted at several function statements.

thank you in advance for help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF NON DUPLICATED ROWS 2
Macro_AND function 2
Formula for data range 4
Is there a specific Excel Function that doesn't this? 4
Conditional Formatting based on active Named Range; IF Function to VBA 1
matching Multiple columns in Excel. 1
Insert Column, Keep Average range 1
Conditional Formatting More than 3 with Formula 9

Top