Creation of a cooking recipes index
Solved
ophanela
Posted messages
8
Status
Member
-
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Bonjour
I want to create an index of my recipes in alphabetical order,
Column A: recipe name, Column B: page number, Column C: book name
However, when I go to: Data, then Sort, column A, values, from A to Z.
It sorts column A alphabetically, but the page numbers in column B and the book names in column C do not move and thus no longer correspond to the recipe next to them!!!!
How can I make them follow?
I am not very familiar with the capabilities of Excel 2010,
Thank you for your help
Ophanela
I want to create an index of my recipes in alphabetical order,
Column A: recipe name, Column B: page number, Column C: book name
However, when I go to: Data, then Sort, column A, values, from A to Z.
It sorts column A alphabetically, but the page numbers in column B and the book names in column C do not move and thus no longer correspond to the recipe next to them!!!!
How can I make them follow?
I am not very familiar with the capabilities of Excel 2010,
Thank you for your help
Ophanela
1 answer
-
Hello
select the entire filled range from A to C
Sort
the window prompts you to choose the column and the sort order
and the entire selected range will be sorted;
(you can add cascading sort criteria (column A, then another one, etc.
by clicking on Add.. in the window
crdlmnt
--
To err is human, to persist is diabolical.
