Thread: how to formulate this???
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FORMULA FORMULA is offline
external usenet poster
  
Posts: 8
Default how to formulate this???
below:
in cell A1, i hv G6
cell A2: P3
cell A3: G1
cell A4: G2
cell A5: P2

how can i formulate G=9 or P=5???
i hv tried the function COUNTIF, but in vain. Help!!!
so many thxxxx
Reply With QuoteReply With Quote