Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel
Resolved · Medium Priority · Version 2007
Reply Fri 26 Nov 2010, 17:00Delegate Sophia said...
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
For upcoming training course dates see: Pricing & availability
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.
Thu 23 Dec 2010: Automatically marked as resolved.
|