Search results

Hi, I have a pivot table where I have pulled data for 2013. The data I have is, item number, date ordered, quantity ordered and the sales amount. So for example if I have oranges, below it it shows order date of 1/1/2013 and the amount ordered and other dates that oranges were ordered. My...

Hi everyone! I know how to use vlookups, hlookups, etc. However, I am wondering if there is a formula in Excel that can help me with this. Say I have actual 2013 numbers by month. Jan, Feb, Mar and so on. Under each of the months I have actual sales numbers and some months have a return...

Hi Everyone! I do not have an issue, but I am looking for some guidance from the advanced users on a budget spreadsheets for business. I have Googled budget spreadsheets and it mostly personal out there. Here is my situation. I have to run it by distributor by month and at this point under...

Hi Everyone, I am working on an excel spreadsheet where I need to lookup the value of 2 items. For example, I need to lookup everything that is a .25 for sales by the month, 1, 2, 3, 4, 5 and so on. So my vlookup is this: =VLOOKUP(A4, Data!, MATCH('By Pump Size'!O2, Data!AK:AL, 2, False))...

I know some of you out there are excellent with Excel charts so that is why I posting this. I am in need of a graph that looks like a bucket in some sense. I want to show my PY Order numbers as a flat line across. Than I want to show my current year orders as another line, and we are down so...

I am working on a price comparison sheet. I have my overall sheet of all items numbers with pricing. I have different worksheets set up for each competitor with their similar products and their pricing. In my worksheet all my vlooksups are working well except for one of the competitors tabs...

Hi, I have a question regarding VLookup. I have a company called Odessa, however, they have three different accounts with three different names. I am trying to create a one line lookup of all three accounts. Is there a way to do a V lookup with some paramaters like _Vlookup, "ODE" ...

Hi, I am trying to do an analysis of some data that I have from 2012 and 2013 on about 12 items. I have to show by month the sales, quantity ordered and % of change. I would like to create a chart similar to the one attached, but when clicking on it, it will not take me to the information to...

I have some pretty large files that were created back in Excel 2003 with conditional formatting. Here is what the rules say: J50 = 0, then no formatting J49 > J50 - Red with white text J49<=J50 - Green with black text Where it should be red, it is coming up green. I have deleted...

My spreadsheet pulls from a Pivot Table by Date. For example 6/3/2013, 6,4,2013, etc. In my spreadsheet it states to lookup the pivot table for that date. I also have in front of the formula an IFERROR in the front and the "" at the end. However, if my date field does not have anything in...

I have Sales Bowlers that I do at the end of every month. I have it set up with months across the top - Jan, Feb, March. Then on the sides I have Stretch, Plan and Actual. Every month I change the formula in Stretch, Plan and Actual to include the next month. For example for Jan - April - it...

Hi everyone! There are a couple of daily reports that I am responsible for that I am still doing a lot of manual updating and wondering if a H lookup will work. This is what I have: 1. The actual data is an Access database that updates every night. So when I open the report, I use a data...

Hi everyone! I am very interested in learning how to do an interactive dashboard. I did download the Excel file that is the example, but I am having some issues understanding it, getting my "whatifs" to work, etc. I wanted to take the class, but my company did not have the extra money to...

I feel really silly posting this, but I have two numbers that I need to plot on a chart - YTD actual number and YTD budget (2 numbers total, i.e. 50,000 and 65,000)and I want to show how the actual number is trending on budget. If I create a bar chart, it comes up with no issues. I want this...

Hi, I am creating a trend chart to show my daily orders, forecast number and then the variance. The daily orders and forecast numbers are ina line format. Then I have my variance as an XY scatter. I am also listing the days of the month that we book orders and we are a day behind so the...