write

Hi All, I'm trying to write an alternative to formula below: If(isnumber(search ("Item1",a2)),"Result1",if(isnumber(search("Item2",a2)),"Result2",if(..... The formula is looking for a specific word in string of text and if found, returning a result. I'm looking for a more efficient way in the...

In this formula If the [[#Totals],[BALANCE]] is $0.00, how would I write this formula not to show the 0.00’s? CheckRegister78910161836[[#Totals],[BALANCE]] Thanks in advance

Can someone help me to write a vba code to search column heading and then sort it

this is what I’m trying to do (If A1>0,1,)+(if A1>60,1,)+(if A1>120,1,)+(if A1>180,1,)and so on down the line I was wondering if there is an easier way to write this so I don’t have to add 100 if statements to a cell?

Hi, I'm trying to use the index match function to find the result where the source (in this case the account) could be in columns A through E, and the month is in row 1. Here is my formula, I know this is not correct, anyone know how to write this correctly? Any help would be greatly...

I have an invoice spreadsheet that needs the ability to write notes at the bottom. I want to lock the spreadsheet but there are a few requirements I need with a text box: The main one is that I need to lock the sheet and keep writing in it I need the text box to expand as you write more lines...

Does anyone know of a way to keep notes on what each step does in Power Query? When I write VBA, I write up a detailed explanation of what each line of code does so if anyone needs to modify it they can understand the method to my madness. The closest options I can find in Power Query are...

One of my workbooks has become corrupted, I printed all the vba, and now I have to retype it all, do I need to put each back into the modules or can I just write each sub one after each other in one module?

I need your help writing an if/then statement in a pivot table - I need to write if c5 is = 1 and d5 is equal to 0, then "closed" otherwise "still open"

ı am working on excel with stock market and ı made an excel and ı write stocks code to A1 cell and when ı write it, excel takes data from stock's sheet. My question is: For example if ı write A1 cell EGEEN and B1 cell 2017/3, ı want to take 2017/3's datas to b1 column. I am learning excel new...

In Excel, I can use ctrl+click on the worksheet tabs to select multiple worksheets. How can I refer to the collection of selected worksheets? I would like to write: For Each ws In Worksheets.Selection [....] Next Of course, that does not work. Alternatively, if I cycle through the...

Could I get some help to write some code to copy from one table to another please? I have the following code I tried to write but because I am still learning to code, I don't know how to debug it. Set tbl = Worksheets("NPSS_quote_sheet").ListObjects("npss_quote") For Each...

Greetings, I have some code that works, but but now I need to make it loop upwards through the blank cells and stop before overwriting the first non-blank cell. I just can't seem to figure out that whole "i = / Next i" thing. Also, in the last "Else" statement if the cell (0,-13) from Active...

Hello everyone, I made a ComBobox (ActiveX control) with 6 items "FR5CP" "CR5CP "NR5CP" "CR5TP" "FR5CU" "CR5CB" I want a solution for this: when I write F it will filter the other ones and stay only FR5CP and FR5CU.I mean to look for the item while writing. nother Thing:when...

Hi. I've created an elapsed time (formatted as [h]) from this formula:-...

Hi, I have different values in column D, if a row in column C or F contains a value from column D I want to highlight the entire row. How do I write a formula for this or Marco? Many thanks

<tbody> Custody 50 Transaction 70 Revenue 1000 Custody/Txn ? </tbody> I'm trying to modify one of my formulas. Essentially I want to write a SUMIF statement where anytime it sees either Custody or Transactions it adds them up. I think it'd be something similar to this...

Hi Guys, I am trying to write an if statement based on the results in cell A1 and i cant seem to get this correct the rules i want to apply in the statement are If A1 > 0.49 then A1=100 If A1 > 0.39 and less then 0.50 then A1=75 If A1 >0.29 and less then 0.40 then A1= 50 how can i write this...

Hello, I am working on a project to dynamically illustrate a guitar scale on a fretboard. At this point the image count is around 2000. I have two identical tables. Table 1 contains true/false statements that indicate, based on selected assumptions, whether an image should be displayed of...

I have the following If formula... =IF(D5-15<P$3,"OVERDUE","NOT DUE")=IF(J5=isnumber,I5,"") How do I write this correctly? The first part works but the second nested IF is not correct. D Column is course date, I Column is todays date minus 15 days (set to remind me that payment needs to have...