All,
I need some assistance in how to best visualize four values over the course of a year.
1 - Forecast Target - is the target monthly forecast set by corporate
2 - Forecast is the division forecast
3 - ON PO are is the amount of sales actually on Purchase Order
4 - Actual is the actual...
I'm struggling with how to best show slippage from the original due date on a PO to the new date. I want to show the original date in black and then the new revised date in red. I need to visually show late deliveries for several vendors. individual charts are fine for each vendor. The gannt...
I while back I saw a bank dashboard that was static and printed a large piece of paper vs being interactive. It was well laid and and very comprehensive. It might have been included in one of the dashboard contests. But I tried searching and didn't find it. Does anyone remember it?
Can someone recommend a tool they use(e.g. macro, vba script, 3rd party tool) to clean and import excel spreadsheets? I download spreadsheets from mainframes to update my reporting tool each day. Invariably, I have to clean the data of erroneous characters and convert text to numbers.
Anyone...
Yes - the first vlookup works correctly. It's the second v(lookup) that does not.
=VLOOKUP(AF3,Buyers!$A$2:$B$120,2,FALSE)
The value in AF3 is the result of a vlookup formula below:
=VLOOKUP(L3,PRALL,8,FALSE)
Well L3 hand inputed PR# and returns the buyer # in AF3. This lookup works fine.
fred,
I cannot post the actual workbook - proprietary and all that stuff. If the last post didn't help then I will create a workbook that has the three worksheets, data and formulas.
I just read re may post and probbaly made it sound different than the reality of the situation.
I have one workbook - with three spreadsheets and eash sheet has been renamed. One is called 'Tables
Another tab is called 'PR' and it contains a list of data exported from another system and...
Hi,
I am not sure if this is the right solution the vlookup() calling a second one to get a value. The main reason I am not sure is simply because it isn't working. Here's is what I am trying to do.
In worksheet A - I Have a value 12345 in a call A1 that is the result of a vlookup in...