https://1drv.ms/x/s!AvjBsEPEq12ngUm0YmMHEk1HGIPY?e=npLKjO
My data has account numbers and their corresponding $ value
Trying to add the $ value for those accounts which are not in the list in Column E
I.e. add column B except the items highlighted in grey
How best would you go about it?
(My...
Hi guys,
I am using this string =IFERROR(VLOOKUP(B:B;H:I;2;FALSE);"not found")
1 Example:
In column B I have following text: Ipad 6th Generation 32gb Space Grey
And somewhere in column H i have following text: iPad 6th gen 32GB Space Grey
And the one in column H are deviate a bit from...
In my workbook after applying update on 3rd August 2019 ,in one particular workbook Slicer and Form controls are disable (grey out) and I could not use.
I am using a workbook in MSExcel 2016 and I have saved the file in *.xlsx format. I tried to figure out every thing by checking in 'Trust...
Hello,
Can you help me with a macro please?
I need to auto populate certain cells in different rows with "N/A" and grey shading depending on selections made in column B from a dropdown list.
For example, if we select "School" in cell B19, then E19 to P19 show "N/A" with grey fill colour and...
I have a table which summarises the number of sales of tshirts of each colour combination (its actually much bigger than this)
I'd like to show a list of the top 10 most popular colour combos so somehow i have to find the highest 10 values from these cells and display a list of them, in order...
Hi All
I have a sheet with a lot of data, and a macro set on a button which hides any rows where the colour is shaded dark grey in a particular column.
I want to put on shading when the value in column A changes (like banding in a table),but only when the value changes and the rows are...
Hi,
I am working on formula to help my staff on their data entry.
We have the primary code in column A and we need to input color of each item in column B
In column C, we then have this formula, =IF(A2<>A1,B2,IF(ISNUMBER(SEARCH(B2,C1)),C1,C1&","&B2))
it basically check if all these 3 input...
Hi,
I'd like to setup a conditional format that will change accordingly to certain Unique ID's.
<tbody>
OAK 1
OAK 1
OAK 2
OAK 3
OAK 3
OAK 4
OAK 5
OAK 5
</tbody>
The conditional format I'd like to run will highlight the cell range A1:D1 when the unique ID is found...
Hello,
I have a spreadsheet with two columns, one has an area name in and the second column has the branch name. Some areas could have 5 branches and some could have 15 branches. I would like to format each row based on the area name. So if its area 1 then say a light grey, if area 2 then a...
Hi all,
Wondering if someone could help me with a problem.
I need a formula do add to conditional formating to auto turn grey lines depending on day change and acording to the table below?
<tbody>
01-01-2019
MONDAY
01-01-2019<strike></strike>
<strike></strike>MONDAY<strike></strike>...
Hi Everyone,
I need a macro not conditional formation for this please.
I have a range of data in sheet "Cals" Range S11:BX and lastrow.
Now Column S holds the clients name and all clients are sorted to be together.
what I need is a macro that can give me two Greys (pref with RGB numbers so I...
I know color code duplicates is a very common issue here on the internet, but I can't find any solution which is similar to my needs.
Based on the value in column A("My data") I want to color code the whole row where the value is the same.
I.e. row 1 and 2 has the same value and should be...
Hello all, I'm not terribly experienced in macros, but I'm learning as I go. Any help is appreciated. I have a workbook with many worksheets inside it. From a master worksheet, I'd like my staff to be able to select which worksheets to print by selecting them with checkboxes. I have a macro...
Evening,
I have a report that is produced from a front end system where names are entered with a comma separating them, some have 1 name, some 2 names some 3 or 4
for example:
Jo Blogs, John Smith
Shaun Green
Betty Jones, Sharon Blue, Harry Grey
Is there an easy way to separate the names...
Hi
I am currently trying to create a formula to count the number of cells of a certain colour that is a certain criteria.
I'm looking for something like a countcolorif function but can't work it out and I'm getting frustrated that I can't work this out!
Basic version below of spreadsheet...
Hello!
I want to make a graph that one of the lines is formed of the data of a range of cells.
However, this range of cells may change with updates. For example, I would like the line to be formed from the GREY cells of a line, so that when I grey more cells, the line will update.
Is that...
On my userform, I have a textbox (uf1vb1_OPS) that has code written to it when clicked by the user executes code which. I wish to mimic as a button.
By default, the shape's SPECIALEFFECT property is Raised (1- frmSpecialEffectRaised). When the user clicks the shape, I want the button to appear...
Is it possible to create custom bands in a table? For example, I have a few hundred rows of content and the first column is an identifier that looks like this:
ClientA-48102-1
ClientB-51556-1
ClientB-51556-2
ClientB-51556-3
ClientB-59900-1
ClientB-59900-2
ClientC-40938-1
ClientC-40938-2...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.