Find last time text entered and return value
Solved/Closed
Gouws
Gouws
- Posts
- 45
- Registration date
- Sunday February 7, 2010
- Status
- Member
- Last seen
- April 15, 2012
Gouws
- Posts
- 45
- Registration date
- Sunday February 7, 2010
- Status
- Member
- Last seen
- April 15, 2012
Related:
- Find last time text entered and return value
- Design a program to print the following pattern sample input: enter the number to be printed: 1 max number of time printed: 3 1 ✓ - Forum - Programming
- The wrong info was entered too many times. try another option, or try again later. ✓ - Forum - Hotmail/Outlook.com
- Which function will you use to enter current time in a worksheet cell ✓ - Forum - Office Software
- Current time by clicking comm button in excel - Forum - Excel
- Enter Time by clicking on a cell ✓ - Forum - Excel
2 replies
rizvisa1
Aug 5, 2010 at 07:22 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Aug 5, 2010 at 07:22 AM
Try this Gouws
=SUMPRODUCT((G1:G10) * (D1:D10="Bolts") * (A1:A10=SUMPRODUCT(MAX((D1:D10="Bolts") * (A1:A10) )* 1)) *1 )
=SUMPRODUCT((G1:G10) * (D1:D10="Bolts") * (A1:A10=SUMPRODUCT(MAX((D1:D10="Bolts") * (A1:A10) )* 1)) *1 )
Gouws
Aug 6, 2010 at 12:17 AM
- Posts
- 45
- Registration date
- Sunday February 7, 2010
- Status
- Member
- Last seen
- April 15, 2012
Aug 6, 2010 at 12:17 AM
Hi rivisa1
It give me : #VALUE back
It give me : #VALUE back
rizvisa1
Aug 6, 2010 at 10:55 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Aug 6, 2010 at 10:55 AM
I used your sample on row 1:3
and used this formula for Bolts
=SUMPRODUCT((G$1:G$10) * (D$1:D$10="Bolts") * (A$1:A$10=SUMPRODUCT(MAX((D$1:D$10="Bolts") * (A$1:A$10) )* 1)) *1 )
I got 13
use this formula for Screws
=SUMPRODUCT((G$1:G$10) * (D$1:D$10="Screws") * (A$1:A$10=SUMPRODUCT(MAX((D$1:D$10="Screws") * (A$1:A$10) )* 1)) *1 )
and got 15
use this formula for nuts
=SUMPRODUCT((G$1:G$10) * (D$1:D$10="Nuts") * (A$1:A$10=SUMPRODUCT(MAX((D$1:D$10="Nuts") * (A$1:A$10) )* 1)) *1 )
and got 10
May be if you post a link to you file that would help
and used this formula for Bolts
=SUMPRODUCT((G$1:G$10) * (D$1:D$10="Bolts") * (A$1:A$10=SUMPRODUCT(MAX((D$1:D$10="Bolts") * (A$1:A$10) )* 1)) *1 )
I got 13
use this formula for Screws
=SUMPRODUCT((G$1:G$10) * (D$1:D$10="Screws") * (A$1:A$10=SUMPRODUCT(MAX((D$1:D$10="Screws") * (A$1:A$10) )* 1)) *1 )
and got 15
use this formula for nuts
=SUMPRODUCT((G$1:G$10) * (D$1:D$10="Nuts") * (A$1:A$10=SUMPRODUCT(MAX((D$1:D$10="Nuts") * (A$1:A$10) )* 1)) *1 )
and got 10
May be if you post a link to you file that would help
Gouws
Aug 10, 2010 at 08:01 AM
- Posts
- 45
- Registration date
- Sunday February 7, 2010
- Status
- Member
- Last seen
- April 15, 2012
Aug 10, 2010 at 08:01 AM
TX, rivisa 1 found the problem it's working 100%
Aug 6, 2010 at 02:03 AM
I'm looking it up from the bottom to the top!