# exp

1. ### SUMIFS Using 3 Distinct Criteria

Good Morning, I was hoping someone might be able to help me out with the following question: I have built a spreadsheet that generates data on a monthly basis for 100 distinct "blocks" (January through December, vertically oriented, 100 times; the example below features only 2 months for 1 of...
2. ### Countif Formula Problem ("< 1 Yr Exp.")

My countIf formula doesn't see to like "< 1 Yr Exp." If I change the data where its looking to lets say "Test" and I change the formula as well, it works fine. so it has to be that I'm using "< 1 Yr Exp." in the formula. < 1 Yr Exp. = (Less then 1 Year expired) =COUNTIFS('CMOP...
3. ### trouble with time in query

Have a query with time values: start times and ending times. for three different individuals. have created exp to come up with the time that has elapsed. (no problem there) created an exp that is to total the times for the three. if the is not 3 sets of numbers the query is not turning in a...
4. ### Need help with formula!

Hi all, I have existing data on the left. I need the outcome shows on right? Not sure how to derive it. Can you guys pls help me out? Thanks! <colgroup><col><col span="2"><col><col span="3"><col><col><col><col><col><col><col span="4"></colgroup><tbody> A B C D E F A B...
5. ### Short Name

Hi...how to make short name in excel exp John Smith to become J. Smith
6. ### Expired expiration date with text in the same cell

Hello, I am looking for a formula that it would let me know when the expiration date going to be expired or has expired with the text in the same cell. For example, Cell A1 contains "ISO 13485:2003 (exp. 2/2/2012)". How do I write the formula to let me know when the date has expired but the...
7. ### VBA Kill file

Afternoon all. I have been struggling with this for a while now and I wonder if you can help. I have a userform which enters data to the database, it then creates a folder, renames it then PDF's all of the worksheets into the new folder. The folder and PDF's change file name based on the...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...