replaced

I'm stuck in my own head - hopefully you can get me out: I have a budget of $1.6 million dollars, but the state is doing a $2 million dollar budget. Can you please help me with a formula that will show the $1.6M replaced with $2M? Thank you so much in advance and if I need to provide you with...

Hi All, I am using the following code, but unfortunately it is not giving the result I want: Dim model As String, Purpose As String, Replaced As String model = Sheets("General Data").Range("B9").Value Purpose = Sheets("General Data").Range("D5").Value Replaced = Sheets("General...

Hi,</SPAN></SPAN> In the data column C I have got random numbers from 0 to 2211 </SPAN></SPAN> I need to replace the random numbers of column C and want to give them number 0 to as long as data find in ascending order. Note: the duplicate numbers will be assignee the same...

I have two Dynamic Named Ranges I need to use in sub E2 needs to be replaced with Named Range nDataCountry 'Standard Values'!$B$2:$B$251 needs to be replaced with Named Range nCountry I am looking for values in nDataCounrty that do not exist in nCountry This working code does not...

I sometimes create sheets to track the standings of sports teams. Some of these sheets contains rankings. Over time, the rankings change. In the past, I have calculated the change in rank by subtracting the old ranking from the new one (=NewRank-OldRank). This works, but can be a little...

what is the most efficient way to look for either this or that within a string. if found, they will be removed or replaced with a blank.

I would like to figure out a way to parse through an excel sheet and replace cell values with a formula. I'm guessing this is done with a macro but I've never created macros on my own and so I am not sure how to start. In the example I want to check if cell A10 is a number in which case, D10 to...

I'm trying to make the value of a textbox become dynamically inserted into a message box. In the code below, I want NAME replaced with Me.TextBox2.Value. MsgValue = MsgBox("Are NAME's documents filed?", vbYesNo, "Training Documents") Thanks!

Say I have 4 quizzes, and there is an optional Review Session. Student gets either 100 or 0 for attending/not attending the review session. If student attends the review, their lowest quiz scores will be replaced by 100, provided the quiz to be replaced is at least 70. Please note that there...

Hi All, I need help with the replace formula in excel. I want to count all characters in a cell and replace all counted characters with a * For example 1234 must be replaced by **** 123456 must be replaced by ****** ExcelDennis must be replaced by *********** Hope someone can help me. Thanks

I am totally stuck with this. I have tried helper cells, substitute and sumif formulas but I cannot get what I want. So, I have a list with values. There is a text and if a word in the text matches a word in the list then it has to be replaced with a word that is in a cell next to the cell in...

Hi all, I have a long list of email addresses from my business's newsletter subscription list, most of which are repeated multiple times within the list. I'm going to send this email list to someone to do some analysis, so I want to make sure the don't have access to the real email addresses...

Looking to Replace a dash with a Blank in Column D Below is what I have. Thank You for any assist. Sub ReplaceD() Dim lastRow As Long lastRow = Range("D" & Rows.Count).End(xlUp).Row Range("D2:D" & lastRow).Replace what:="-", replacement:="", lookat:=xlWhole End Sub

I have the following date in A2 down Columns A: V:\Quotes\!Pricing Department Folders\Tools\BOE TEMPLATES\Under Development\Q015742 BOE Import X1.xlsm Colum B: 5/22/2018 10:11:13 AM Column C: ENGINEERING_SMITH Columns A: V:\Quotes\!Pricing Department Folders\Tools\BOE TEMPLATES\Under...

Hello all. This is probably a simple one that I am just having problems figuring out because I am still learning VBA. But I am trying to loop through a column (Q) and replace any values that are Text with the current time and leave any numeric cells alone from rows 2 to 3000. I've tried every...

Really do struggle with this I have this formula which equals 21 =MATCH(Table11[[#Headers],[CTZ3]],Overseas!$A:$A,0) I need the 21 in the following to be replaced by the first formula =SUMIF(Overseas!$4:$4,[@[Week Commencing]],Overseas!$21:$21) I guess it's INDIRECT but that's where my...

I have 3 columns of data, and I want to edit the first column of data. How would I write a formula so that for each cell in the first column, it searches the second column for a match. If there is a match, then the first column cell is replaced by the corresponding third column cell. So for...