Thread: Intersection
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stephen Bye Stephen Bye is offline
external usenet poster
 
Posts: 28
Default Intersection

You can use
=Cum Defects
and Excel will treat this as the intersection of the column labelled Cum and
the row labelled Defects.

"Jithu" wrote in message
...
Hi All,

Is it possible to find the intersection cell of two cells.

for eg
Goal Cum Curr
Pro
Defects ?
Estimate

i want to find the cells id(A2, B4 etc) of the intersection of cells with
data Defects and Cum(given as "?" in the eg)


Thanks in advance for the help.

Jithu