In Excel, I want to compare 2 spreadsheets and only show entries where a particular column has changed.?

If the items are in the same order on both lists then you could simply copy & paste one to the other (if you need to insert a space to do this, click on a cell to the right of where you want it inserted and click Insert > Column). To identify those which have changed, enter the following in the top cell of the column next to the two lists, which I'll assume are in columns A and B:

=IF(A1=B1,"","CHANGED")

Press Enter, then point your cursor to bottom right-hand corner until a black + appears. Click on the + and hold while you drag the cell down to the same row as the last one in your list to copy the formula to all cells.

If your two lists are not in the same order, highlight all the items in the lists and also any other columns containing associated data. Then click Data > Sort and in the top dropdown box, select the column which contains the list. You can choose Ascending or Descending as you prefer, then click OK. Repeat this procedure for the second list and then copy & paste and follow the procedure above.

Hope this helps

You need to perform a vlookup function to bring over the price from the previous day's spreadsheet =vlookup(a2,yesterday.xls!$a$2:$z$65000,3,false)

a2 is the item in today's file that you want to find in yesterday's file

the range is the range of data starting with the "item"

3 represents the number of columns to the right that has your price

i might want to open both spreadsheets interior a similar window. Then do a (non everlasting) variety by using date call, in spite of is least confusing for you. then you definitely can examine for the time of and catch the misses honestly.