I have to columns: AgencyID and Number of devices sent.
I need to sort by device but I am having trouble because the device column is a formula. How can I sort a column that has formulas. Remember that I am sorting 2 columns not just the device column. Thank you!
MArvin
I would copy and paste over the formula then sort.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
What is the formula in the cells?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi , I copied and paste it but I would like to know if there is way to sort formulas. Please see attached. It is a COUNTIFS formula
Yeah, make a pivot table and it's all dynamic for you.
iPad Inventory_test.xlsx
Change the formula to:
Formula:
=COUNTIFS('2014 Avon iPads by Agency'!$B$2:$B$65,B3,'2014 Avon iPads by Agency'!$C$2:$C$65,"Yes")
Your lack of using absolute references makes your original list wrong with the counts because the range was being incremented with each row that the formula was copied to on the SOrt worksheet. With the range ABSOLUE, it remains the same when filled down.
Your formula as entered on SOrt B3 starts out as:
Formula:=COUNTIFS('2014 Avon iPads by Agency'!B2:B65, SOrt!B3,'2014 Avon iPads by Agency'!C2:C65,"Yes")
and ends up as this at the bottom of the column:
Formula:=COUNTIFS('2014 Avon iPads by Agency'!B41:B104, SOrt!B42,'2014 Avon iPads by Agency'!C41:C104,"Yes")
As you can see, the range references have changed drastically from the top of the column to the bottom of the column.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank you both- Newdoverman: I will fix this. Thank you.
mikeTRON: this is what I needed. Thank you so much.
Fix the formulae before creating the Pivot table because the values in your list as it stands are not correct.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks