Spreadsheet question

H

Howard Brazee

I am trying to create a table in a page of an Excel 2000 spread sheet.


This looks at a table on page 1 of the spreadsheet:

Column E has a code letter
Column F has a date
Column G has a score

Page 2 has a cell with our current date (which overrides the real current date)


I want to create a table on page 3 that only has data from page 1 where:

1. Column E has "t" or "T" and the score is one of the 20 most current scores.

and

2. Column E has a "t" or "T" and the score was made with the last 12 months.


I would rather not use Visual Basic if I can avoid it.


How would you recommend I make this table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Insert Index into a Table 1
Changing margins on 2nd page of letterhead template 4
Create if partial match then copy and paste data from one cell to another 1
How to do an IF statement that copy data based on a partial match 0
VBA - exporting serial letters to single documents 0
Finding totals withing a seven day period 9
Calculating an average of data between two dates 1

Top