I am trying top place a sequential value to my booth numbers by name. I am having issues when there are:
2 instances of non sequential numbers "example: KS GOLF KARTS, INC" 144-155 [Desired Result: 144-146 & 153-155]
When there is an Alpha character in the numeric values "example: GARAGE...
I have a table with golf scores for a junior golf tournament with the following columns: name (A2:A101), age (B2:B101), round 1 score (C2:C101), round 2 score (D2:D101), and round 3 score (E2:E101). All golfers participated in rounds 1 and 2 and half the field competed in round 3. The ages...
Hello-
I've been searching forums all morning trying to find a way to find a way to get the minimum value using two criteria. Here's a sample of what my data looks like, and ideally what I'd like to see as a result.
<tbody>
Case #
Size
Date
1
Small
201501
1
Small
201512
1...
Hi All
I am looking to find values on a large data sheet and export to a report.
What I have is a training record with several NAMES and several COURSES (split into modules) each module is given a number of points. I would like to be able to select a name and display the persons weekest area...
I'm tasked with identifying some very specific figures in an inventory report. I could certainly accomplish my task by using some VBA, but I prefer to use a formula.
My data is in a table (tblInv) and the fields from which I need to draw data are:
[Rep] = employee's name, stored in named...
I am using the current MAX formula to extract the latest date from
column H, based on conditions in column A and column C.
How can I re-write this formula to extract the earliest date from column H,
as replacing MAX with MIN does not work.
When I replace with MIN, the result = 1/0/1900...
Is it possible to do a min-if function without making it an array formula?
I've got a file where I'm using a whole bunch of these and it is really slowing my file down and ballooning the size of the file.
Example of what I have:
{=MIN( IF(A1:A2=4,B1:B2,"") )}
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.