Help

Iggvsbsb

Banned - Rules violations
Joined
Jan 19, 2021
Messages
20
Office Version
  1. 365
Platform
  1. Windows
Hello my friends.
Please help me .
Thank you
Nr crt.nume autor denumirea cărțiiAnul apariției editura preț
1tar
ion
apa
cartea
lac
1857Albatros12
2bar
ana
ograda
masa
calculator
1569BBT1446
3mihet
Ion
canapea
lampa
2009Albatros43
4lat
vasile
geam
foc
1987LLT987


Requirements: All requirements are solved on different sheets example Requirement 1 I solve it on an exel sheet Requirement 2 I solve it on a new exel sheet by copying the table and so on. 1. to be sorted alphabetically by "nume autor " and "nume carte ". 2 to filter only the books published by "editura Albatros "3. to filter only books with a “ preț “ between 12 and 650. 4. to be ordered by “editura”; for the same “editura” , make the order according to the decreasing “preț “
Thank you !!!!!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
This appears to just be sorting and filtering. What part are you stuck with?
 
Upvote 0
Both of those are just sorting, which you can do using the Data - Sort menu options. You can sort by up to 64 fields.
 
Upvote 0
1. first Filter Price for your Criteria
2. Sort based Descending Order Based Price
3. Filter Based Publication House
 
Upvote 0

Similar threads

Replies
1
Views
129

Forum statistics

Threads
1,214,936
Messages
6,122,340
Members
449,079
Latest member
rocketslinger

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top