I have a table and I filtered to get specific rows. Now I want to define a
formula in only visible rows. Like subtract the lower cell from the above
cell but this becomes: AI15=(L15-L4) in filtered table. Up till here it is OK
Now I want to drag this formula down but it perform the formula if the
hidden rows are visible. AI30=(L30-L19)
Is there any solution to this?
--
R. Khoshravan
Please click "Yes" if it is helpful.