with Excel spreadsheets there are four steps I always go through before
starting with anything.
what I do is apply filters. With big tables there is always some filtering
needed — Under Home tab and Editing section choose Sort & Filters and then
click on Filters.
„=” and „randbetween”. Then put in brackets and between them the
first number is your lowest and second is the highest between which the random
number is generated.
your table and sort the column where the groups are displayed. To sort, go
under Home and Editing section. Click on „Sort & Filter” and choose on
of the first two. Next go to Data and click on Subtotal. Under „At each change
in” select the column the group is in. In the next section select the
function you want to be used and in the third bit select the column the
subtotal is added to. Click on OK when you’re done.
We have 2 big sheets with data and we want to compare them. Our first sheet includes all the products we have in inventory as at August 31 and the second sheet contains inventory status as at September 30.