Results 1 to 7 of 7
Thread: Excel
Hybrid View
-
4th July 2015 10:00 #1Registered User
Join Date: Jan:2008
Location:
Posts: 1,852
Excel
,
, , 7500 . ( )
1
1 2 3 4
2
1 2
-
4th July 2015 11:31 #2-==-
Join Date: Sep:2003
Location:
Posts: 6,444
-
4th July 2015 11:49 #3Registered User
Join Date: Jan:2008
Location:
Posts: 1,852
. 1 (1) (B1), 2 , 90% 1. 1 1 B1 2 B1.
, B1 1 2.
-
4th July 2015 12:49 #4
VLOOKUP , .
1. MATCH ( ). "" .
2. CONCATENATE (=concatenate("=sheet1.b";[ .1]). - .
3. "=sheet1.bX", "paste special - text" , find-replace "." "." () , .
- . VLOOKUP- , . ( ). ""
It's not about what science can do for you. It's all about what you can do for the science.
ignore list:Zabluden
-
16th July 2015 15:39 #5Registered User
Join Date: Jan:2011
Location: Sofia
Posts: 48
Vlookup range_lookup 1 true.
=vlookup(" ";" ";" ";" ")
!Last edited by jorkoto; 16th July 2015 at 15:43.
-
4th July 2015 13:12 #6
-
4th July 2015 13:21 #7Registered User
Join Date: Jul:2004
Location:
Posts: 621
Google Spreadsheets =DGET(Sheet1!A:B, "", {""; A1}) B1 . Excel




Reply With Quote

7th May 2023, 16:02 in PC