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

Search results

  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]?
  15. salmonchild

    Data Validation [List Prediction]

    I don't know of a way to make data validation auto-suggest based on initial text input. you can use the dropdown menu to show the list contents- do you have too many list items for this to be practical. I would add that the lack of response may have something to do with perceived attitude in...
  16. salmonchild

    Conditional Formatting Help- Condition based on value in separate table

    Chaps- thank you very much. Since posting I put in a workaround by having a helper column =IF(COUNTIF(Talent!$A:$A,'Retail Master'!$E2)>1,"Y","N") and then based the CF on that. I am running it down 6000 rows so I don't think it will slow the calculation time of the sheet by too much. I am...
  17. salmonchild

    Conditional Formatting Help- Condition based on value in separate table

    Afternoon followers of Chandooism, I'm stumped again on solving a problem, even 6 cups of tea in a two hour period has not helped me. I have a table of data that I would like to apply conditional formatting to. I would like, when people enter a location (4 digit code), for the whole row to be...
  18. salmonchild

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

    Cheers Luke, if I know the range of cells that from the page, e.g. A1:K30 is there another line I can put in to make that the 'active sheet' for the save. It is always awesome to see how clean the VBA can be if you know what you are doing- I usually search for the different components or...
  19. salmonchild

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

    Excel warriors, A cheeky request for a bit of scripting- could anyone please provide me with VBA code to save the current active sheet as a .pdf in a defined network drive, and for the name of the file to be a combination of the text in cells A1 A2 and A3? I have managed through recording a...
  20. salmonchild

    Slow excel

    I have found that some links can be really stubborn and do not break through the normal excel command. The find link add-in by Bill Manville on this page can be useful: http://www.oaltd.co.uk/MVP/Default.htm
  21. salmonchild

    Problems nesting IF and SEARCH functions {SOLVED}

    SIrJB7- thank you, now I see the logic and it works. Cheers guys problem solved.
  22. salmonchild

    Problems nesting IF and SEARCH functions {SOLVED}

    When I separate it and just do the SEARCH it returns a value of 1, can I make my logical test SEARCH(("*Advisor*",B2)=1)? Will try that now. Cheers HUI
  23. salmonchild

    Problems nesting IF and SEARCH functions {SOLVED}

    Afternoon all, currently having trouble nesting the above functions to return the result I want. I have a column with job tiles in it, there are three job titles though a couple of instances for each e.g. Trainee Customer Advisor and Customer Advisor, Assistant Manager and Customer Service...
Back
Top