?

Status
Not open for further replies.

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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Duplicate to: Help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.

Also please give your threads proper titles, rather than just ? or Help
 
Upvote 0
Status
Not open for further replies.

Similar threads

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

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