Comments

tansm11 (46)in hive-102332 • 5 years ago
RE: Dynamic Positioning of Totals using Dynamic Arrays
This is what I did using Microsoft Excel online. For pull in the Amount of the invoice into column H: In cell H5, as I typed in =SUM, a drop-down list appeared, and I double-click on SUMIFS and…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.18
Past Payouts $0.18
- Author $0.09
- Curators $0.09
0
tansm11 (46)in hive-102332 • 5 years ago
RE: Dynamic Positioning of Totals using Dynamic Arrays
Okay, I will use Excel online.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
0
tansm11 (46)in hive-102332 • 5 years ago
RE: Dynamic Positioning of Totals using Dynamic Arrays
I have went through the video above and I couldn't get the understanding on how to apply the dynamic arrays onto the Learn and Earn Activity above without entering a formula to each cell. I'm…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
2
tansm11 (46)in hive-102332 • 5 years ago
RE: Dynamic Positioning of Totals using Dynamic Arrays
For pull in the Amount of the invoice into column H: In cell H5, I typed in =SUMIFS(C1:C11,A1:A11,A2). In cell H6, I typed in =SUMIFS(C1:C11,A1:A11,A3). In cell H7, I typed in…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.18
Past Payouts $0.18
- Author $0.09
- Curators $0.09
4
tansm11 (46)in hive-102332 • 5 years ago
RE: Dynamic Positioning of Totals using Dynamic Arrays
I got it. Thank you, Paula.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
0
tansm11 (46)in hive-102332 • 5 years ago
RE: Dynamic Positioning of Totals using Dynamic Arrays
@paulag Paula, is the video above on how to create Dynamic Positioning of Totals using Dynamic arrays using Excels SEQUENCE function, has anything to do with the above Learn and Earn Activity? Are…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
2
tansm11 (46)in excel • 5 years ago
RE: Learn and Earn STEEM Activities
are you excited about the opportunity to earn while you learn Excel? Yes, I'm very excited. I can learn Excel and earn at the same time. where did you hear about The Excel Club and our Learn…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.03
Past Payouts $0.03
- Author $0.01
- Curators $0.01
0
tansm11 (46)in excel • 5 years ago
RE: How Use Excel T.TEST - Was a Marketing Campaign Successful?
Learn and Earn Activity 8: Copy the table of data below and work out if you could call the marketing campaign a success or not by carrying out a T.TEST By using the T.TEST, the marketing campaign…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.23
Past Payouts $0.23
- Author $0.12
- Curators $0.12
0
tansm11 (46)in excel • 5 years ago
RE: Excel Dynamic Arrays – A new way to model your Excel Spreadsheets
Learn and Earn Activity 7: Are you excited about this change and the introduction of Excel Dynamic Arrays? Leave a comment below telling us what you think of these changes and how you can see your…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.22
Past Payouts $0.22
- Author $0.11
- Curators $0.11
0
tansm11 (46)in excel • 5 years ago
RE: How to carry out a VLOOKUP within Text in Excel
Excel Learn and Earn Activity 6: What text function is needed in this case? MID What is the full formula that you used? =VLOOKUP(MID(A2,4,2)+0,$E$1:$F$7,2,FALSE)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.21
Past Payouts $0.21
- Author $0.10
- Curators $0.11
0
tansm11 (46)in curation • 5 years ago
RE: HOW TO Always EARN STEEM with @JacobTS Curation on STEEMAUTO
@jacobts Is this still on? I have followed all your steps above.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
0
tansm11 (46)in excel • 5 years ago
RE: Learn Excel Pivot Tables in less than 20 Minutes
Yes, they are.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
0
tansm11 (46)in excel • 5 years ago
RE: Learn Excel Pivot Tables in less than 20 Minutes
Learn and Earn Activity 5: How often do you use pivot tables and what feature of a pivot table is your favorite and why? I haven't use pivot tables before but from this blog I like the feature…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.18
Past Payouts $0.18
- Author $0.09
- Curators $0.09
0
tansm11 (46)in excel • 5 years ago
RE: The CHOOSE function in Excel
Earn and Learn Activity 4: Tell me what formula did you use to return the selling price? =CHOOSE(B11,B2,B3,B4) What is the formula used to return the Units sold? =CHOOSE(B11,B7,B8,B9) Which…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.24
Past Payouts $0.24
- Author $0.12
- Curators $0.12
0
tansm11 (46)in steemit • 5 years ago
RE: Presenting UpvoteBank - NEW UPVOTE SERVICE
Done.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
0
tansm11 (46)in excel • 5 years ago
RE: Excel Power Tools - The Future of Excel
Earn and Learn 3: Thank you for sharing this knowledge, Paula. Did you share this post? I shared it in Twitter. Which Excel Power Tool do you use the most? I have never use any of the tools…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.04
Past Payouts $0.04
- Author $0.02
- Curators $0.02
0
tansm11 (46)in steemit • 5 years ago
RE: Presenting UpvoteBank - NEW UPVOTE SERVICE
register
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
2
tansm11 (46)in excel • 5 years ago
RE: Funnel Charts In Excel
Learn and Earn Activity: In your organization where could you apply funnel charts instead of a table of data? In my organization, funnel charts are very suitable for Sales & Marketing department.…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.24
Past Payouts $0.24
- Author $0.12
- Curators $0.12
0
tansm11 (46)in partiko • 5 years ago
RE: Free Upvotes everyday for everyone
@sharingiscaring1 Hi. I have left you a message in your Discord group ( Get daily free upvotes is still available? I've followed all the steps in #start-cutation-trail channel. What happen to your…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
1

tansm11 (46.27 Elementary)

Comments