# formula needed

1. ### Help!!! I have no clue where to start.

I am stumped! I am trying to figure out a formula and it is jut not working. I am working with SKU's and UPC's. Where I work I am dealing with product that has either a SKU or a UPC on it, and I am currently in the process of having to verify where product is in the warehouse. What I am needing...
2. ### Avarage of remaning balance needed by formula pls

hello all, i need a formula to help me getting the remaning avarage of the below Buy 100 X 1500 = 150000 i need here avrg of the buying 100 buy 152 X 1505 = 228760 i need here the avrg of buying 252 sell 200 X 1510 = 302000 i need here the profit of the selling according to the...
3. ### Formula Help Needed -- Not exactly sure what I need

Hello, Any help will be greatly appreciated :). Using my example below, I want a formula to look for the Territory ID in Table 2 and find it it Table 1 and when it is found sum up only Value1, Value2 and Value5 (Columns B, C, F) for that row. In the example -- the answer is 9. I can't figure...
4. ### Urgently need solution, too tricky for me

Sorry the first post was messed up... I have used match function to compare cell A:A to cell E:E, if there's a match cell D displays either true or false. Where there is a match I want the name of that product from cell A to appear on another page. So A...
5. ### Need help with IF function

In column A I have dates from 1/1/16 to 31/12/16 In cell d2 I have employee start date. In cell d4 I have leaving date I need column to show employment status for everyday using the start date cell and leaving date cell as point of reference. If start date is after 1/1/16 I want cells in...
6. ### Need a formula to keep characters before a dash (-)

I have a large list of data with the format of xxxx-xxx-xxxxxxx-xxxx (see examples below). I need to pull the data in front (to the left) of the first dash (-) into its own column. The rest of the data (to the right of the first dash) can be deleted. FYI, the data in front of the first dash...
7. ### For every multiple of - formula needed

So I'm trying to write a program to automatically fill in specifications of parts at work for quality inspection. our general tolerances for parts are +/-.25mm up to 125mm, then .1mm for every 25mm thereafter. If the measurements are within specifications, nothing needs to be displayed. If they...
8. ### Need to count the number of FirstNames in a column

I have a spreadsheet that I would like to get a "headcount" for our membership. Example: A B C D 1 LastName FirstName email address 2 Doe...
9. ### Next Date in a series with known start date and frequency.

Help desperately needed. I don't think this should be too tough but for the life of me can't figure it out. I need a formula for Column C which will auto populate based on today's date Today(). Since we know the start date and the frequency, I just need to formula which gives me the next date...
10. ### Trying to figure out the formula

Okay, so after reading some of these questions I feel really excel stupid, but I won't get any smarter if I don't ask so... I'm trying to create a formula where excel will add numbers in one column only if the adjacent column's drop down list is on a certain value and then subtract that total...
11. ### DATEDIF function

I need a datedif formula to look at the months and days between two dates and display only the months. However, i need the result (number of months) to be rounded up if the days are 15 or more and rounded down if 14 or less. right now i'm using this formula, but i'm not sure how or where to...
12. ### Tax IF formulas?

Hey, I need help figuring out an IF formula that would allow me to calculate the tax owed. The tax rates are 20%, 25% and 30% and the full bracket total for 20% is 4,000\$ and for 25%, 11,500\$. In D14, I have as a taxable income, 20,000\$ and In E14, I would need a IF formula that calculates...
13. ### Applying formula to Column based on rows.

I am making a product information spreadsheet for a business I am starting. I haven't worked with excel for a couple years so I feel that I have forgotten everything! My formulas are simple. I will give you one as an example, it starts at H2 and continues down. Down the column it appears like...
14. ### VLookup and IF Formula Needed

Hello, I am using office 2003 and have the following data on two tabs (there are about 4000 employees): Sheet 1 Column A - first name - ex: Joe Column B - last name - ex: Smith Column C - emp # - want to pull emp # from sheet #2 based on match with first and last name Sheet 2 Column A -...
15. ### Array formula to find/return a related value

I am an extreme beginner when it comes to Excel programming, so I was wondering if someone could help me. I am getting a CSV file from a web site which has columns of text values. Let's say one has A-Z. I have a worksheet that has 2 columns where if a1 is the value A, A2 is Andrew, b1 = B, b2 =...

### 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...