• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by salmonchild

  1. salmonchild

    VBA to save page as .pdf, name to come from cell values

    This has been working brilliantly for over a year - props to Luke for the code. My requirements have changed a little now and instead of a .pdf of the active sheet I would like it to save as a workbook in .xlsx format- is there a tweak to this code that can change the file type? I did some...
  2. salmonchild

    Find an excel file

    You might have to enable 'searching within files' on the folders you keep your workbooks in, also indexing those locations will make the searching faster.
  3. salmonchild

    Average days between two status points, multiple dates for each point.

    Hello all, I need some help to see if what I am trying to do is possible and if so how. I am summarising/calculating information from our 'raw' data to be the back end of a dashboard display. All the data for the DB needs to be in the same table to facilitate slicers working across all charts...
  4. salmonchild

    Conditional formatting Formula help please

    @Somendra Misra and @ThrottleWorks , thank you both for your input and solutions. It looks like I was just a couple of iterations away from your solution Somendra- it has been a long day with many problems so I was perhaps too keen in giving upn and asking on here! Excel inner peace has been...
  5. salmonchild

    Conditional formatting Formula help please

    screencap attached this time.
  6. salmonchild

    Conditional formatting Formula help please

    structure example attached Somendra. @ThrottleWorks it works partially, I can see how the helper colum works and how the CF should apply however if I can avoid helper columns that would be good and also the application of the CF in your example does not work as it should (this may be a a...
  7. salmonchild

    Conditional formatting Formula help please

    Hi all, Could someone please help me with a formula for conditional formatting? I need to format the whole row based on a date, whereby if the date in column BI is within a week either side of today's date (which is fixed on another sheet in cell 'Legend and Pivots'!D1) the text of the row is...
  8. salmonchild

    Quick Date format question

    Fantastic, didn't think to use the TEXT function. Need to engage my brain. Thank you very much Abdul!
  9. salmonchild

    Quick Date format question

    If I am missing something very simple, please don't shoot me! Need to change this: 2014-01-03 12:53:21 +0000 To be like this: 03/01/2014 For about 10,000 rows. I have tried formatting the cells to no avail and have managed by using something like -=LEFT(A34,LEN(A34)-13) to remove the...
  10. salmonchild

    Slicer- link to two separate data sources

    Had a thought- is it possible to have a cell populated by the text of a highlighted slicer option?
  11. salmonchild

    Slicer- link to two separate data sources

    Afternoon Excelentrics I have rather spiffing dashboard with multiple slicers controlling multiple pivot tables, so far so good. All pivot tables are based on the same source data hence the slicers working on them. I would now like to introduce a new data source (independently generated...
  12. salmonchild

    Can a logical test work for this?

    IT'S A FORMULA WALK OFF!
  13. salmonchild

    Consolidating KPIs

    I don't think this answers your question regarding benchmarking a consolidated KPI, however the page below shows a pretty nifty dboard Chandoo put together for a call centre type environment- it makes it pretty easy to visualise various KPIs on one page rather than consolidating...
  14. salmonchild

    Conditional Formatting Help- Condition based on value in separate table

    Mods/Ninjas is there a way to alter the thread title with [SOLVED]?
Back
Top