Nice Information
Loading...
186
subscribers
3,617
video views
Uploaded videos
1-10 of 15-
How do Pull data from different column?
NiceInformation
524 views
Using If to pull Data from different column in Excel
-
How do sum with many criteria?
NiceInformation
99 views
Using Sumifs, Eomonth or Pivot table in Excel
-
How to separate the first name, middle name and last name?
NiceInformation
1,757 views
PROBLEM 1:
How to remove dot and dash in the middle of number?
PROBLEM 2:
How to separate the first name, middle name and last name?
Problem solving 1:
=REPLACE(...
-
How do claim priority with some condition?
NiceInformation
9 views
PROBLEM 1:
How do I claim priority to the following conditions:
- The first priority is taken from the far right when a smaller number working day
- If you found a worki...
-
Categorize data jeeps and sedan
NiceInformation
17 views
Problem 1:
Categorize data jeeps and sedan, based on its year and miles
What formula can be used to get results like that in the "Category"
Formula problem solving:
...
-
How to counting due date your credit card?
NiceInformation
93 views
PROBLEM:
How many days late from the due date until now?
PROBLEM SOLVING:
=IF(DAYS360(C5,TODAY(),TRUE) higher than 0,DAYS360(C5,TODAY(),TRUE)&" Days","")
-
How to make Dynamic Line chart for cash balance using Excel?
NiceInformation
147 views
PROBLEM :
How to make Dynamic Line chart for cash balance using Excel?
-
How to add column of categories to apparel data set?
NiceInformation
29 views
PROBLEM :
How to add column of categories to apparel data set?
PROBLEM SOLVING:
=VLOOKUP(RIGHT(D2,LEN(D2)-SEARCH("-")),$G$2:$H$5,2,0)
-
Removing Visa card, Merchant Account, Amex in parentheses
NiceInformation
16 views
PROBLEM 1:
How to remove the information in parentheses?
PROBLEM SOLVING 1:
=TRIM(LEFT(A7,FIND("(",A7)-1))
PROBLEM 2:
How do I totalize Brand in the DATA1 with t...
-
Comulative interest for a loan
NiceInformation
9 views
How to find Cumulative Interest For a Loan
Advertisement
About Nice Information
more
less
Play all(15)