Recent content by ps40life

OK, great. I normalized the data and it looks good. Great tip! Now, when you say simple lookup, a vlookup only can use one factor. I have heard you can use Index and Match to do a multiple variable lookup, but that is usually when the factors include one column variable and one row...

Hello, I have a factor table that looks something like this: Dep. 20% 30% 40% 50% 1 26500 35200 41200 45500 2 30000 36000 45000 51000 3 32000 37500 41250 47000 The numbers under the percentages are earnings, so with one dep up to 26500, you get a 20% discount. Two...

OK, so what are my options?

I agree! So, is there any good way to suspend protection, maybe with a macro, so you could use the drawing tools, then re-protect without losing form field data?? [ponder]

Does anyone know how I can use drawing tools on a protected Word form. I have a "graph" area that I want to be able to draw circles, squares, etc. on. I tried to protect only the other sections of the form and I can TYPE in the graph section, but the draw tools are disabled. Thanks...

Does anyone know why the status bar option would not be available in Excel 2000? It is listed on the View menu, but it is grayed out. No files open or anything happening. Always happens this way-cannot view status bar. ?????

XLBO: I have tried your suggestion and I think in a situation where all the criteria columns were the same, it would work very well. My problem is that most of the criteria only look at one column. So, in order to cover all possibilities, I would have to build a table for many criteria that are...

To XLBO: I think I understand your idea and I wouldn't mind skipping code at all! But what happens when the criteria is only in two of the cells, and not the third? I always take into account the bldg type, but the surface and membrane may or may not be included. (I am sorry, my little data...

Hello, In an Excel spreadsheet, I used a nested IF statement in each cell to do this, but the number of variables has increased and I think I have to go VBA with it. I have one cell that is assigned a cost factor. It is determined by checking a combination of 2-3 different cells. E.g., If bldg...

Hi, I haven't found an answer to this, so... I need to find the salary of a person as of 8/1/2003. I have a history table that lists the date of a salary change and the amount. For example... Emp 1 5/3/01 54,000 Emp 1 6/4/02 57,000 Emp 1 8/6/03 59,000 So, I need the 6/4/02 record at...

Interesting and humorous post! As someone on the other side, who receives the help, I hope I always come across as grateful for the answers I receive. I have had, as someone mentioned, answers that I had no idea what to do with it. [ponder] I consider myself a technical user, but I have been...

I have a crosstab query that counts students by gender and breaks that into ethnicity. It works fine, except that the grades don't sort the way I want. An ideal sort would look like this: EE PK K 01 02 03 etc...through 12 Presently, it sorts the numbers first, then alpha with EE, K, PK. Is...

PaulF, Thanks so much for the advice. I set up a query on the system table and it works perfectly. I can filter out whatever I don't want to show through the query. Excellent advice!!! Susan [2thumbsup]

To dhookom: I had a table set up, but I am going to be relocating and my user is on her own after that. She is beginning to create her own reports now and I thought it would be easier to code the combo box list to update automatically as she adds new stuff. She is a new user, so she is not...

To Lego: Thanks for the reply. I will try the IF statement, and I am also going to look at PaulF's suggestion. FYI-I was previously pulling the names of the report from a table. Problem is, you have to constantly be adding new report names to keep the list updated. I wanted to automate for my...