achieve

Hi All, Any help with the following would be greatly appreciated :) This is my current formula: =IFERROR(INDEX('Devices'!$A$1:$V$999,SMALL(IF('Devices'!$D$1:$D$999='IOS Search'!$B$1,ROW('Devices'!$D$1:$D$999)),ROWS($1:1)),1),"") However I want to replace 'Devices' with a cell value i.e. $C$1...

Hi everyone, I'm using Excel2013. On my excel sheet, I'm trying to achieve 2 objectives: (1) to see when a client last submitted a work order, and (2) should not return the same date. My current code is this...

I am trying to create a spreadsheet that will generate action plans for colleagues on development programmes. What I would like to achieve is the following: - one sheet will have an empty action plan form, including several empty cells which will be populated with the required tasks - another...

Hey Team, So I've got a target spreadsheet for sales. And I would like to have an image appear based on the value of the cell. So for instance A1 will be there target A2 will be there actual sales A3 will be an image based on their result. With the image being a bronze circle if they achieve...

Hi I have a spreadsheet with 3 columns Date Code Total There are multiple rows for each date - average 100 per date. I want to achieve the following 1. Group by date 2. Show the top 4 records for each date based on the Total column. All help grateful received

The picture shows what I want to achieve: Values are GREEN if positive & RED if negative, however I need some of those values to be BLUE based on same row tag from another column (like the "C" tag on Column A or the word "Type C" on Column B) I can achieve the GREEN & RED coloring with just 2...

So I am trying to achieve a for loop macro that stops when certain conditions are met. Say A1 is the counter that starts at 0. for every tick you get 20% of A1 +1 and 80% of A1 -1, and A1 is always >=0. The macro stops when A1 reaches say 5. How do I achieve this? Thanks in advance.

Hi I have never used VBA before and need help with the following. I need to convert a date to the shortened abbreviation of the day of the week that the date relates to. i.e. 26/06/2017 = Mon. in excel I can achieve this by using =text(A1,"ddd"), when i have incorporated this into a VBA...