Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# value in the last record

Posted on 2012-03-28
Medium Priority
256 Views
Dear experts
Need an excel based formula which check for unique value in column A (variable) and then post 10% in column D.

Kindly help.

thank you
value-in-the-last-record.xlsx
0
Question by:Excellearner
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 37776712
Enter this in D2 and copy down

=IF(COUNTIF(\$A\$1:A2,A2)=COUNTIF(A:A,A2),10%,"")
0

LVL 9

Expert Comment

ID: 37776788
The formula below assumes you are looking
for a value of 500 in range A2:A8 and returns
10% of value if found, otherwise blank cell.

=IF(ISNUMBER(MATCH(500,\$A\$2:\$A\$8,0)),INDEX(\$A\$2:\$A\$8,MATCH(500,\$A\$2:\$A\$8,0),1)*10%,"")
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
###### Suggested Courses
Course of the Month10 days, 11 hours left to enroll