Results 1 to 13 of 13
Thread: Excel
Hybrid View
-
6th January 2019 15:53 #1Registered User
Join Date: Jan:2019
Location: sofia
Posts: 1
Excel
!
, .
:
, , 10-15 .
, .
5 (, , , , ). - , , . , ( ) (. ), "" (, , ., , )?
, , , . . .
drop down data validation, 1 , .
!
-
6th January 2019 15:57 #2Banned
Join Date: Aug:2006
Location: Varna
Posts: 869
(. ), . .
-
6th January 2019 21:41 #3
?
- ? .. , , ...? ?
- . , - Data Validation -> Allow: "List" -> Source: .
, , - VLOOKUP, Concatenate ( , "CHAR(10)" " " , )., , , .: ( ) - (); (..) - (..).
-----! , ...
-
14th August 2019 11:06 #4
.
14000 -. / 80 , .. -. . - 80 - 1000 ., 81 - 1100 .
.MSI B450 Tomahawk | AMD Ryzen 7 5700X & Arctic Liquid Freezer II 280 | Kingston FURY Beast 2x16GB | EVGA RTX 3060 Ti XC GAMING | WD SN850 1TB | Seasonic Focus GX-850 | be quiet! Pure Base 500 | LG 27GL850 | Edifier R1800TIII
-
14th August 2019 12:00 #5
, . - C.
1. Data/Sort C. - D TEXT ( =Text(C5,"0") ). -. LEFT ( =LEFT(D5,2) ) 2 -. , . Data Subtotal. - Use function "count". add subtotal to - E. summary below results. . .
2. , - , - . Data/Filter. Number Filters/between. 8000000000 8099999999. - 80- . , .Last edited by all; 14th August 2019 at 12:03.
-
14th August 2019 13:56 #6Registered User
Join Date: Apr:2003
Location:
Posts: 2,762
:
LEFT, LEFTB functions
Description
LEFT returns the first character or characters in a text string, based on the number of characters you specify.
Count ...Last edited by rrado; 14th August 2019 at 13:57.




Reply With Quote
...
7th May 2023, 14:24 in