Search results

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

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

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

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

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

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

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

Hi everyone, have been soaking up the excel awesomeness on this site for a few weeks now but am stumped on something that I can't find a pre-existing answer for. Running 2010 on Windows 7 Problem- I have a workbook with a few sheets, it is used to track the vacancies of my client and their...