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
Is there a specific Excel Function that doesn't this? 4
Ranking Numbers with Text 1
Number of IF statements exceeded... 7
matching Multiple columns in Excel. 1
trying to write function to find data in last row in 1 column 1
Conditional Formatting based on active Named Range; IF Function to VBA 1
Help with creating a Macro 6

Top