Sophia has attended:
Excel Advanced course
Excel
Hi,
How do I get formulas into filtered cells without it also being input into the hidden unfiltered cells.
Tried: Copy & paste which changes the formula somewhat as the outcome differs from the 1st cell i have copied from.
dragging/ dble clicking on bottom right corner of 1st cell to replicate formular down also inputs into the unfiltered hidden cells.
thans in advance
Sophia
RE: Excel
Hi Sophia,
Thank you for your question.
Do you mean using autofilter to filter out specific results and then create formulas based on the results?
If so, have you tried functions such as the database functions(e.g. DSUM) or others like COUNTIF or SUMIF?
Regards
Simon
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
