formula

G

George A. Jululian

HI

I have a formula in one cell and want to know the formula came from which
row number
 
M

Monkey-See, Monkey-Do

Just click on the cell with the formular in it and the formula appears in the
formula toolbar above the cells containing all of the information used to
calculate the contents of the cell.

This should give you the info you want!
 
G

George A. Jululian

Sorry it did not

i know the formual but i want Result of the formula came from which row
number
 
F

FSt1

hi
Another way....
2003.....
on the menu bar....
tools>formula auditing>trace precedents
2007...
formulas>formaula auditing

Regards
FSt1
 
D

David Biddulph

Why not tell us the formula, then we might see why you are having trouble
ascertaining the relevant row number(s).
 
Top