View Single Post
  #1   Report Post  
Steved
 
Posts: n/a
Default What do I need to do here please.

Hello from Steved

I've have two worksheets named Summary and City (1)

ok the below will give me the first numeric number off 1721 which is 1
Which is in the Summary Sheet.

=IF(1-ISERROR(F6),IF(ISNUMBER(--LEFT(F6)),--LEFT(F6),LEFT(F6)),"")

ok in Sheet named City (1) I have =IF(Summary!A6=1,ROW(),"")

I want to take out
=IF(1-ISERROR(F6),IF(ISNUMBER(--LEFT(F6)),--LEFT(F6),LEFT(F6)),"") from the
summary sheet and put it in City (1)

ok this is my attempt
=IF(1-ISERROR(Summary!F6),IF(ISNUMBER(--LEFT(Summary!F6)),--LEFT(Summary!F6),LEFT(Summary!F6)),"")*IF(Summary! F6=1,ROW(),"")

It is displaying #VALUE! I am asking it to read from Cell F6 on the sheet
Called Summary.

Please Help Thankyou.