-
21st November 2013 13:28
#1
Back2Business
Join Date: Oct:2008
Location:
Posts: 379
Excel
, . , E6 ( 0 9) G6 ( 0 5) D10 : D14, .. 6=1, G6=3, 4.
-
21st November 2013 13:49
#2
Registered User
Join Date: Aug:2009
Location:
Posts: 265
- - D, D10: =A10+C10*10 .
-
21st November 2013 14:03
#3
Back2Business
Join Date: Oct:2008
Location:
Posts: 379
-
21st November 2013 15:01
#4
Registered User
Join Date: Aug:2009
Location:
Posts: 265

Originally Posted by
Bennett
, 6 , G6 , .
- .
-
22nd November 2013 11:13
#5
Registered User
Join Date: Feb:2011
Location: Varna
Posts: 12
, , :

:
=INDEX($D$10:$D$14,MATCH(E6&"|"&G6,$A$10 :$A$14&"|"&$C$10:$C$14,0))
, array formula, .. Enter, Ctrl + Shift + Enter
.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
7th May 2023, 16:02 in PC