Thread: Using text in one cell in another cells formula.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
asg2307 asg2307 is offline
external usenet poster
  
Posts: 21
Default Using text in one cell in another cells formula.
How do you use the text data in A1 "REDDOG1" in another cell "=COUNTIF(Sheet
2'!E:E, "=REDDOG1")" I have to edit several hundreds of line for =COUNTIF
when copying and pasting.
Reply With QuoteReply With Quote