98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Medium Priority · Version 2007
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
Mon 29 Nov 2010, 10:12Trainer Simon said...
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
Thu 16 Dec 2010, 15:45Trainer Nafeesa said...
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.
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 tip:Select only cell that contain text to lock formatFor selecting cells that only contain Text in Excel |
