Recent content by jfussell

WOW! Thank you everyone so very much!! I ended up just swaping the columns and adjusted the formula and now it works like a champ!! Thanks again for all your wonderful instructions!

OK let me try and answer everyone's questions in this post... John, my columns look like this... A B C D FL Delaware Alaska AK MN Mississippi Alabama AL HI Hawaii Arkansas AR IL Hawaii Arizona AZ etc A = lookup value B = VLOOKUP...

My VLOOKUP function seems to be giving me the results from the prior row. Here's what I have... 4 columns: Column A is my abbreviated states lookup value Column B is where I want my results displayed Columns C&D are my table array where I want the results to pull from column C So, here's my...

My company wants me to create a template for our corporate styles, mainly just setting it up for all employees to use the same font and paragraph style, etc. This needs to be done in Word and Outlook; I think I was able to accomplish this in Word using the normal.dot, however I'm still having...

Thank you all for your suggestions. Access database was going to be my last option due to network and data import to Excel complications. There are multiple people that use this spreadsheet. I haven't tried DSUM formula before so will have to play with that a bit before I'd know if that is...

This is a BIG and time consuming question, so any suggestions would be greatly appreciated. I've tried 2 different ways with my layout and calculations but neither way works for me, so I'm looking for suggestions on the following: Worksheet 1: purpose is to enter the monthy sales per customer...

WOW so simple! I tried that one and it worked great. Thank you very much!

OMG the simple things that can reek havoc to a formula... In my actual formula I had entered Input!C21="0" even though I wrote it correctly here...*sigh* Thank you so much for your time xlhelp.

Ah, you're right, thanks! However, when I plug in 1 under EMR Full Time it calculates the formula correctly, but if I plug 1 under Combined Full Time it doesn't give me 40. I'm still having problems with this formula somewhere...

I think I'm missing a very simple step but I'm just not seeing it... On Input sheet I have this: Column B Column C Row 13 | Combined Full Time | Row 14 | Combined Part Time | Row 15 | Total Combined | =SUM(C13:C14) skip a few rows Row 19 | EMR Full...

That's too bad. Thanks for your help xlhelp!

I had entered a column of states as the 2 letter abbreviated text. Is there a way to change that abbreviated text to actually spell out each state correctly?

We had a consultant produce an excel spreadsheet to help drive our 5 year financial. In one of the cells he uses this formula {=TABLE(,B7)} What does this mean? To give a bit more explaination, B7 = $1,568 Then where the above mentioned formula resides are the following info: $1,568 (D4)...

I've created this document that has multiple areas of numbering with 1. 2. 3, etc. and a. b. c. etc. I was able to restart numbering through numerous sections of my document, but for some reason there's this one section that refuses for me to right click and select "restart numbering". In this...

Thanks to everyone that has posted and given me suggestions. However, I decided to take the easy way out and went with dhookom's suggestion; and now my query works!! But I do want to leave a thank-you note to PHV and jbpez for your time helping me with my problem. Everyone gets a star for the...