easier

I have the following formula but want to use INDIRECT function on the column name within the table GANNT so becomes easier to update =IF(F$7<$C$2,0,SUMPRODUCT(--(GANTT[WK40_2]=$B$11))*E$8) Have tried the following but get a #REF...

Hi all, i have a question on time format when vlookup. how can i easier to identify (conditional formatting with color or vlookup to return with my request only?) the table below if i want greater than 18:30(subject to change in A1) <tbody> 18:45 21:30 17:15 16:30 21:00 19:45...

How can I correct this formula: =SUMIF('001'!A21:A31,"Labor",'001'!G21:G31)+SUMIF('002'!A21:A31,"Labor",'002'!G21:G31)+SUMIF('003'!A21:A31,"Labor",'003'!G21:G31) I want to remove the "Labor" since I have Labor typed into this cell 'Cat&Markups'!A2, so I want it to reference that cell instead...

Hi all, So I am writing a code to select multiple columns. Here is what my code would look like: Columns("B:B")... Columns ("E:E")... Columns ("H:H")... Is there an easier way of selecting all of those with only one "Columns"? The ... is there just for the example. Thanks in advance.

Hi I want to ask user to enter address for example 100 main street, and then my code will split the number and street name. I tried the following but got error message. I am thinking of array must be use or do you think there is easier way to do that thank you very much Sub myfirst() Dim...

I am familiar with using Custom Sorts for secondary sorts in tables. However, I was wondering if there is an easier way. Generally, one can simply click on the drop down arrow in a column header while holding the control key to designate it as a secondary sort, but that doesn't seem to work in...

Hi guys!!!! I have this data of weight meassurements, i have one measurement for every hour of the last 5 years, but the format of the table its not useful for me, I need to change it to another format. The one in green is the one i have, the one in yellow is the one I need. <tbody> I used...

Hi The following if statement works perfect =IF(AND(B698="abc",G698="charge"),+C698,IF(AND(B698="abc",G698="payment"),-C698,IF(AND(B698="abc",G698="credit"),-C698,""))) When I add another condition ( made it red so it can be easier to see here), It returns “false” when the new...

Hi, I am really new in htlm coding, how can I ghe ID tag of loging boxes for website when there's no id= and the name is hidden. some the websites are easier to find them as will have like id=username etc but some them no how can find those, much appreciated your help. thank you.

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?

Hello, I used the below formula to pull in the earliest date found in different cells...

I have this formula in one of my worksheets: =IF(OR(D5=H5,E5=H5,F5=H5,G5=H5,H5=H5,I5=H5),0,"NO") It's actually even longer and more complicated but this is a good example. Instead of writing H5 like 5-10 times is there a way to make this easier? Ie if any cell in D5:I5 = H5, 0, else "No" Thanks!

I have a number of spreadsheets with many macros, one in particular with nearly 400. Whilst the sheet and the macros work fine, when I edit macros I note that the later ones are "saved" in separate modules. My tidy mind says that it would be neater and easier to search and edit if they were all...

Hi, Wondering best way to do this? I read about using offset but will be volatile right Example: A10: =SUM($A$2:A9) Any easier way to do this in a table?

Hi. Would appreciate any help. I have a userform with 100 Textboxes on it. The majority of the textboxes will be for the DISPLAY of cell values only. With some being used for the input of new data which the goes onto the worksheet. My question is. Is there an easier way to get...

how would I write a conditional formatting rule that highlights anything in red for the cells in column H that have more than 30 characters in the cell? basically column H is my journal entry description and our accounting software cuts off any characters that exceed 30. I just think it would...

<tbody> </tbody> Hi all, https://imgur.com/a/X0sW0kE Would anyone know a formula which sums all oranges in january, but only if the value of the cell is at most 10? So in the attached example it would come to 19. I have had a play with the SUMPRODUCT formula but can't get this to...

Hi guys, Starting to use Office 2019 to track profit and loss (please don't digress on using accounting software). Is there any template I can use to make it easier for me? E.g. to handle different currencies, taxes, and insertion of recurring fixed expenses? Thank you.

Probably one of the easier questions. I tried to record a macro and copy the code.. didn't work so well. Sooo... here we go! There are 4 sheets, each has a header. Do I need to specify all columns that exist in the sheet? There is a filter present (no criteria specified) - if that makes it...

Hi I want do check student marks and based on the value I will make excel to type a,b,c,d,f. If >80 then A, if >70 then B etc. I can do that using nested if. But lets say I have 10 conditions, is there better way to do that? if function will be complicated. I wonder if there is something easier...