Hi guys!
I have kind of a complex question.
It all starts with a very large spreadsheet (let's call it 'raw data'). It has many columns of information (A:GD).
Much of this data is pretty useless to me, to be honest.
But there are a few pieces of information that I want to extract (if the row...
I have the following code:
Selection.End(xlDown).Select
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Selection.ListObject.ListRows.Add AlwaysInsert:=True...
Hello All,
I have a large spreadsheet which I am working off (20+K rows)
The following is a formula which I wrote, but when I fill down, it takes a long time to process, so just wondering if there is a way to simplify it.
Any help would be greatly appreciated.
=IF(A1="",""...
Hello Guys,
=IF(AND(CELL("format",A2)="D4",
CELL("format",B2)="D4",
CELL("format",C2)="D4",
CELL("format",D2)="D4"),
"is in DATE Format",)
above formula is to check if all values in A2 to D4 are in date.
my boss challenged me to simplify above formula.
please help me. :)
Hi
I've got this formula which works correctly but is a bit long winded and has a few nested IF statements;
=IF(G7="eombh",INDEX(E2:E22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),IF(G7="eom",INDEX(D2:D22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),(INDEX(C2:C22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)))))
G2=...
Dear Sir
Can you help to simplify below code since it is making excel sheet slow
Sub sbClearCellsOnly()
Range("B6:P6").ClearContents
Range("B10:P10").ClearContents
Range("B14:P14").ClearContents
Range("B18:P18").ClearContents
Range("B22:P22").ClearContents
Range("B26:P26").ClearContents...
Hi I am using below formula in a cell,
F4 =(IF(AND(B4="MONEY TRANSFER",E4="1"),SUMIFS($R$4:$R$8,$P$4:$P$8,"<="&D4,$Q$4:$Q$8,">="&D4),IF(AND(B4="MONEY TRANSFER",E4="11"),SUMIFS($R$4:$R$8,$P$4:$P$8,"<="&D4,$Q$4:$Q$8,">="&D4)+3.5,IF(AND(B4="MONEY...
Hello,
Normally if we have a table such as
<= 5 A
>5 B
>10 C
So if I have a number 6, it will give me B.
We all can use Vlookup for this range thing.
However, if I have an IF formula like below, I can not translate it into a Vlookup one:
=IF(A1>10, (A1-5)/200...
Hello,
So when you pull a cell
say
<tbody>
Result
Stat
Something
=B2*(C3/C4)
</tbody>
So in A 3 i want it to say B3*(C3/C4) but if i were to pull the A2 Cell A3 would end up being =B3*(C4/C5)
How would i go about doing this?
up until now ive been editing a few hundred manualy...
Hello I have tried to simplify my example as much as possible.
I have a Column C containing student names. In Column D is the answer that student chose on a test, and in Column E, I have the correct answers to these questions.
In A2 and A3 I have the students names
In B2 and B3 I would like to...
Hi everyone :),
I have a long macro code and I'm wondering if there is a way to simplify it since it has been created from the macro recorder tool.
Here is the macro code:
https://anotepad.com/note/read/6n32gn
I hope that my post is clear enough.
Thank you.
Hi,
Is there a way to simplify the below Formula?
=IF(INDEX('Data Sheet'!$A$1:$P$73,MATCH(A3,'Data Sheet'!$A$1:$A$73,0),12)=0,"N/A",INDEX('Data Sheet'!$A$1:$P$73,MATCH(A3,'Data Sheet'!$A$1:$A$73,0),12))
Hi, I'm writing some code which is quite repetitive because I have a data range from column A:AO
This is how I wrote my code:
Sub UpdateRefineData()
Worksheets("RefinedData").Select
Dim lrow As Long
lrow = Range("A" & Rows.Count).End(xlUp).Row
Range("A3:A" & lrow).FormulaArray =...
is there a way i can simplify this formula?.. because it will be too long if i have 50 cell to sumifs..
SUMIF(AdditivesCalc!$I:$I,$A3,AdditivesCalc!$K:$K)+
SUMIF(AdditivesCalc!$L:$L,$A3,AdditivesCalc!$N:$N)+
SUMIF(AdditivesCalc!$O:$O,$A3,AdditivesCalc!$Q:$Q)+...
Hello - How can i clean the below formula -
=SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name1"))+SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name2"))
Please help thanks
I have the data like given below till Low =0.5, High= 1.49, and Grade = 1 My need is, if I enter a number in a different cell, say 95, I need that...
We've detected that you are using an adblocker.
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.