Let's say you had 35 sales during the past year. You list each sale in Row 1, starting in Column B and you list each sales region in Column A. For each sale, you enter the response rate for each area.
To see which sales had a 75% response rate for the Eastern area, follow the steps below:
In the Eastern area row, click on the first cell that contains 75.
Press Shift | Space to select the entire row.
Press CTRL | \ in a selected row.
Excel will select all the cells that did not match the active cell so you can see which sales had a 75% response rate.
0 komentar:
Post a Comment