Hi all,
I am trying to find the way to obtain the minimum value from a range, with some conditions.
So I have column A with some list of products, and each one have a list of countries (column B). Column A therefor has many duplicates, and Column B should be unique values, per each Col A...
Hi all
I've got a formula which is designed to look at a target value and match all the customers who have that target value. It works perfectly up to a certain point, whereby it returns incorrect values. By this I mean that it returns a match for each customer in the database (when it should...
I have two sheets , one is for repaired car and another one is for returned car so I am trying to create an index formula that returns the returned car's brand name , Mechanic name and the problem but the information isn't accurate
Note: there is only one car per brand name , which means if...
Hello, I am having an issue with Excel.
I got an array-index formula on one sheet (SearchSheet) that returns values from another sheet (DataSheet) based on date or name searches-inputs.
So if I enter 15/5/2015 it will return all the values from my datasheet, whose dates are the same or the...
Hi all!!
you can se on the top table the data base
on the bottom table i need to extract unique names based on the fruit criteria
let me know
tahnk you in advance!Excel...
I have a list of football results
<tbody>
Stoke (cell K8)
0 (cell L8)
1
Aston Villa (cell K9)
1
0
West Brom (cell K10)
2
2
Sunderland (cell K11)
2
2
Stoke (cell K12)
0
1
Tottenham (cell K13)
1
0
Arsenal (cell K14)
2
1
Stoke (cell K15)
1
2
Man Utd (cell...
Hi, I am looking to create an index array. the conditions for the array are based on drop down menus. I want to have it that if the drop down menu has * in it, the array should calculate everything rather than a specific value.
={IF(ROWS(I$14:I14)>$H$7,""...
My data
A1:a8
00
02
04
56
99
I am trying to make a small( function work that will not count blank cells
my values in b1:f1 should be
b1=00, c1=02, d1=04, e1=56, f1=99
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.