Hi, I got this code from another post.
The solution is amazing and really helps me.
I would like to know if there is a way so I can 'Find' and 'Replace the exact value'
The values I'm replacing with are hyperlinks. So I would like to replace the new values with those hyperlinks and keep them...
As per the title, I have two cells, B2:C2 that I need to apply Conditional Formatting to.
Where B2=A2, both B2 and C2 need to have the same formatting applied. Cells are on different worksheets as below.
Worksheet 1
A2=Apples
Worksheet 2
B2=Apples
C2=0.5
Many thanks.
The FVSCHEDULE formula requires a single range of cells with the series of interest rates.
However, I need to build this series of interest rates through a dynamic formula.
Therefore I need a way to combine "[Formula 1]+[Formula 2]+[Formula 3]..." into a single range, or an expression that...
Goodmorning ,
I have to calculate the first quartile (25 percentile) and the third quartile (75 percentile) of a multiple, non-contiguous cell range.
While calculating the minimum and maximum of the same non contiguous cell range, the min and max functions also work on multiple cell ranges, the...
Hi there,
I am trying to apply conditional formatting across a worksheet, based on this formula;
=BC3<BC14 (turns cell green if the value is lower)
HOWEVER
I have read multiple forums/blogs/posts about this and I can't seem to get the conditioning to apply across further rows/columns. I am...
Hi all,
I've been searching for an answer to this for some time now and I'm sure there is probably a simple solution. I have a large table in which some cells have text and the rest are blank. On a separate sheet I would like to have a list to include the text from the cells and disregard the...
I have over 100,00 lines of timesheet entries in Excel and would like to calculate how much overtime per week our team has done and to check the seasonality of the overtime. This is so I can try to make a business case to hire more staff.
Below is an example of our data. Most days have more...
Sheet 1:
P=Presnt
A=Absent
<tbody>
ID
1-Jan-17
2-Jan-17
3-Jan-17
4-Jan-17
5-Jan-17
6-Jan-17
7-Jan-17
8-Jan-17
9-Jan-17
10-Jan-17
001
P
P
A
P
A
A
A
P
P
A
002
A
P
P
P
P
A
A
P
P
P
003
A
A
A
A
A
P
P
P
P
P
004
A
P
P
P
P
P
P
P
P
P
</tbody>
Sheet 2:
<tbody>
001
1-Jan-17
6-Jan-17...
Hi,
I've been trying to find anything related to my question but all I get is multiple results that match the same reference. Ex. If a have
<tbody>
Name
Color
John
Green
Dave
Red
Matt
Red
</tbody>
I would look for red and I would get "Dave" and "Matt".
What I am looking for is:
If...
I have been working on a code that i just cant get right.
I am sure the correct macro is here somewhwere, i just cant find it. I am working with 1400+ sheets in 1 workbook. I need to be able to cope a cell range from each sheet to one master sheet. and i need to be able to do it 3 times. or...
Hi everyone! Please let me know if my question makes sense or not. I created a combo box to make searching a data validation list easier. However, I was only able to do it in one cell and need that same combo box for about 600 more cells so that any new entry they can continue to search. Is...
Hello,
I'm trying to figure out if this is possible. I want to use a vlookup (or any formula) to return the lowest value of 5 specific values. We have 7 INDIVIDUAL MODEL NUMBERS. Then we have PACKAGE MODEL NUMBERS that include 5 of the INDIVIDUAL MODEL NUMBERS. In (Column D, Rows 2,3,4) I...
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Range="$C$3") And (Target.Range=$C$3) Then
Call Macro1(Target.Address(False, False), Target.Value)
End If
End Sub
I am trying it to detect changes made in cell C3 and D3 and if changes are made in both the cells only then call...
Hello everyone,
I have a macro set up that asks for a beginning date and an ending date, then scans columns J-Y for a date that falls within that range. If the macro finds a valid date, it copies and pastes the cell containing the date and the cell directly to the right of it onto another sheet...
This is a rookie question but I have searched several Knowledge Bases/Blogs and have not yielded any results that were helpful.
I am trying to write a programming statement to achieve the following:
I am checking 2 different cells looking for specific data and then posting results based on...
Hi,
I have a Yes / No data validation list in column A. When Yes is selected I want rows B - T to be locked and want it unlocked when it is empty / no is selected.
The below code works brilliant but only when one cell is inputted with Yes. When multiple cells in column A are inserted with Yes...
Hi,
I am struggling with a macro to set multiple pivot items based on multiple cells. I have tried different codes but they don't work as they should be.
In this case, I would like the macro to set the months based on cells "'Validatie'!AQ2" and "'Validatie'!AQ3". These cells contain numeric...
Hey all,
I think an image is the best way to show what I want:
Right now, I have three rules set to check cell $A$3 against $A$1. I would like these same rules to apply to the entire columns, though, so:
$B$3's formatting depends on $B$1's value
$C$3's formatting depends on $C$1's value
...
Hi all,
I know this is very specific... I have set up tracking sheets for each of my 27 members of staff. Each of them has their own folder (which has restricted access to just them), which contains 1 work book per month for the new financial year. Each work book is identical, with a summary...
Hello all I am new here so im sorry if this has been asked and answered but this is what I am looking for.Currently I am using VLOOKUP like this =IF($A8="","",(VLOOKUP($A8,MASTER!$A$1:$G$1500,6,FALSE)))I have changed my master sheet to allow conversions so now I enter the master sheet like...
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.