Dear All
I have 100 Rows in sheet 1
I need to Filter in column A with a criteria
and Put Sumifs Formula in J Column
Now My requirement is Apply Formula in Filtered Range and
Paste that as Values.
Dear All
I have 100 Rows in sheet 1
I need to Filter in column A with a criteria
and Put Sumifs Formula in J Column
Now My requirement is Apply Formula in Filtered Range and
Paste that as Values.
Try this
After you filter the data > Select the Whole filtered column (Till the last used row) where the formula is to be applied > Type in the required Formula > Commit using Ctrl+Enter
To Paste As Values, clear the AutoFilter and then Paste as values
Cheers!
Deep Dave
I need to paste without clearing filter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks