Hey guys I seem to be stumped!
I have a spreadsheet and I am trying to get a value in an individual cell based on two rows of data on two different tabs and then multiply by another row of data :oops:
Sheet 1 has
column A, 63 lines with numbers
column B, 63 lines with numbers
Sheet 2 has...
I got a task in which i have 2 Files
One is a Master File containing the names of the clients and the EMI amount with Payment 1 detail
And there is Another file containing Daily Collection with payment 2 Detail
In Master File there are two column
Pay 1
Pay 2(Values Coming From Another File...
Hi all,
I would like to:
Check if row value in Column AM = "APAC"
Check if row value in Column AR = "APAC"
Check if row value in Column AJ has partial string match containing "OFIA"
Check if row value in Column AJ has partial string match containing "Intra-Asia"
If all above...
Hi Excel geniuses, I'm looking for help simplifying this ugly (but working!) formula.
First it performs a test to see if a PO is over or under a certain number. (Thank you @Peter_SSs and @etaf !)
Based on that PO Number, I direct the next calculations to one of two VLOOKUP tables — one has old...
hello,
I have a text file with blocks of data defined by parentheses, something similar to
(
asas
dsdss
)
(
wwqee
weqqe
)
I need to extract the content between the parentheses. the problem is that sometimes the parentheses are nested.
any suggestions?
Thank you
Looking for a possibility of making this formula shorter, any ideas? Thanks
=IF(AND(INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),7)=0,INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),8)>0),INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),1),"")
This formula is producing this
The active cell is A6...
Hello,
I'm relatively new to more complex nested formulas in Excel (Windows, 2016) and would appreciate some assistance. I’m trying to add a condition to an existing formula that currently performs vlookups based on the text of another cell (H3); the new condition that says if cell H2 contains...
Hi all
Need to check if both matches are on the same row
=row(A6)=row(B6)
which works, but i need it nested within my other formula
=IF(AND(COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),A6),COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),B6)),"Match","No Match")+
Cant work it out, could...
Hi all
My formula is developing nicely, but i need to add in one last check but cant quite think how to incorporate in, hope someone could help.
I need to be able to make sure that the matches im looking for are on the same row as each other.
My formula looks like this so far...
Hi All bit of a complicated one to explain, so bare with me.
There are two workbook lets call them Book1 and Book2, i need to find if there are match's(multiple criteria)
Each Book has a tab called Tab1, Book1 has more columns on then Book2, but the columns never change place.
On Book2 i need...
Hi there
First post, hopefully I've followed the rules. I've had a good search but can't find anything specific to the issue I am having. It's very basic so I'm surprised it isn't working.
I've attached an image that hopefully clearly explains the issue I am having. Basically I'd like to...
Hello, could you please kindly help me with the below, to make it so that it'd only consider values for the calculation if the corresponding value in column 'A' = "XX", and instead of specifying the range, sums up all the matched values in a given column?
Please also note that values start in...
Hi,
First time posting a thread, long time user/reader of threads. I need help solving a problem that I can't find the answer (or close to the answer) to.
What I want to do:
Given a table of data which includes Part number, quote date, quantity, price and supplier, I want iterate through the...
Trying to write this formula and keep flat lining.
If G2 is a error (always #VALUE ), return blank...otherwise run the below if statement
IF(ISNUMBER(G2),"1","0")
Can anyone help I am really struggling.
Hello,
I am trying to write a macro that sums several layers of nested subtotals. The lowest level subtotals (subtotal 2) are already calculated and pulled from another tab. Subtotal 1 needs to ONLY be the sum of the individual Subtotal 2 lines. In my example below, the first subtotal 2 field...
I'm been working on a nested formula, with the other parts working but after a week I've worked out my problem is here and it still gives me #Value . After a full day trying several solutions I'm about to 'scream'...
Hi
Could you please help me to fix the below formula in column and its drop down (by increase cell count) till the last row in the VBA Macro
=IF(C2<2,"0-1 Days",IF(C2<3,"1-2 Days",IF(C2<4,"2-3 Days",IF(C2<6,"3-5 Days",">5 Days"))))
at the drop downing Column C has to increase...
Hello, can you please help point me in the right direction on this formula.
Basically it has 3 conditions depending on day count.
If <60 it should return “80%”
If >60 but under 180 it should return 75%
And if over 180 it should return 65%
I am trying this but it wont work...
I am attempting to write a nested if formula that currently looks like this =IF(I15:L15="NA","NA",IF(I15:L15="No","N",IF(I15:L15="Y","Y",""))) and am not getting the expected results. Currently cells I-L all equal NA. I'm sure I did something wrong and am looking for guidance to fix this or even...
Hi. I'm creating a spreadsheet for a music group that pays tutor expenses for travel. For a round trip up to 200 miles the standard payment is £25, for a round trip of between 200 and 400 miles its £50, and anything over a 400 mile round trip pays £100. What I want is to be able to enter the...
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.