Hello,
My problem is one i have been trying to over come for a while now.
I have a few dashboards that have images of graphs that are taken using the camera tool. This is because they need to be rotated etc.
When i print the report to PDF using the in built Save As PDF the images of...
Hello,
Does anyone have any experience with histograms with different widths?
Similar to the graph in this image:
http://www.gcsemathstutor.com/images/information/info-histogram.jpg
Thanks
Terry
Hello,
I have a match formula bringing me back the reference of the cell i need however i need this in AZ etc.
Is there a function that can do this?
Thnaks
Hello,
Error statements:
2003 =IF(ISERROR(STATEMENT),"ERROR MESSAGE",STATEMENT)
2007 =IFERROR(STATEMENT,"ERROR MESSAGE")
The $$$ are limiting your average to c2:c13.
Thanks
Hello,
Im sure i saw a post before where chandoo had 2 lists of names and he made a list new list of unique names only in a third list.
i.e.
List 1:
Cat
dog
mouse
bat
list 2:
cat
bat
flag
hammer
list 3:
Cat
dog
mouse
bat
flag
hammer
How is this done?
Thanks
Hello,
Is it possible to change the criteria of a bunch of pivots at once?
What i want to do is i have month as a criteria (in number 1,2,3...) I want to change all to look at a different month at once.
I know i could use VBA...
Use index and match.
=Index(Value,match(Sheet1.Location & Sheet1.Material,Sheet2.Location & Sheet2.Material,0)) then hold Ctrl Shift and enter.
Replace Sheet1.Location etc with the cell you want to look up.
What this does is index the column that contains the data by finding the...
Hello,
Happy New Year!
How do I limit the amount cells a user can see?
How do I create a little drop box next to a cell to allow the user to select the cells value with out using a drop down box.
Thanks
Terry
Hello,
What i am looking to do is count the amount of records that meet more than one criteria.
For instance i ahve a column with names in and a column of outcomes.
I want to count when the names column (A) = "GODZILLA" and Outcomes (B) = "Started".
How can i do this?
Thanks
Have you looked at a database for this sort of thing rather than Excel?
You could do it in Access fairly easily (with a form and a recorset) and link the data back in to Excel for reporting.
I would try to keep away from using Excel as a database (which imo it sounds like you're doing)
Right what i have done is use the crieria for an auto filter as a var and work it that way.
This does work however i would love a way that does not use VBA.
Any ideas?
Thanks
Hello,
I have a large table of data in Excel.
What i have currently is a summary table using indexing and matching which shows performance of whoever is selected in a dropdown menu.
What i want is whoever is selected on the main sheet filter and only show me everything associated to...
Hello,
I think i have an interesting question.
Can you use a formula to change the size of text?
I have a list of names and ranks. I want the higher ranked names to be larger.
Any idea?
That doesnt seem to change much.
If I use Webdings rept("g",A1) it works better but the size of the blocks is too large.
My intention is to create a solid bar btw.
Can you recomend a different option?
Thanks
Hello,
I have a series of incel charts working of the REPT("|", A1) A1 having a %*10 to make a chart.
I need a performance indicator. I tryed adding a line where 100% was over the incell bars. However when you print preview the Incell look different in Print preview then in the dashboard...