Hello,
I have a question. I would like to calculated ratio's from a database with balancesheets in a pivot-table. The data is as follows:
<tbody>
Company
Balance Sheet no
Description
Value
Year
Apple
3
Cash
25
2018
Apple
4
Inventories
35
2018
Apple
5
Short Term debt
75
2018
Facebook
3...
Hello all -
Hoping you can help me out here. I am trying to count up cells that contain freeform text and can't seem to figure it out.
The column is a 'How did you hear about us' list and it includes three standard options plus a freeform other field. Users can select multiple options so I...
all the links stopped working to day 14/2/19 when i click on a hyperlink i get the message. cannot load the data to open. I have a file with 400-500 link to facebook pages. only about ten of them follow the link. big help i have tried every thing. thank you Frank Rowley
<tbody>
A
B
C
E
F
G
www.reddit.com/r/news/blahblah
r/news
News Politics
1871511396470
www.old.reddit.com/r/news/blahblah
r/pics
International
90712378456
facebook/groups/1871511396470
r/dogs
Dog Lovers
/doglovers123
facebook.com/groups/catsgalore
r/cats
Cat Lovers...
Guys I want to create a code , This code will query a subject for example "facebook" and will count how much emails received with this subject from inbox and will put these emails in specific worksheet that i create with the name "facebook" for example
Hi,
I have data on seven worksheets, examples below:
<colgroup><col><col><col span="2"></colgroup><tbody>
Worksheet 1
Name
Contact number
Quantity
Company
Richard
1234
10000
Amazon
Mike
2345
5000
Amazon
Michael
5678
3000
Amazon
Nancy
4567
5000
Amazon
Alpha
6789
8000
Amazon
Bravo...
A (Stock)
Facebook
Amazon
Netflix
Google
Facebook
Google
B (Action)
Buy
Sell
Sell
Buy
Sell
Sell
C (Quantity)
100
50
75
100
100
50
D (Price)
150
1000
150
1000
175
800
What's a formula if I wanted to see how much I spent on buying just google? (Google + Buy -> Quantity * Price)
Thank you!
Hi, my brain has turned to blancmange attempting to solve this one on my own. Help is needed, please.
I'm trying to return the column values of rows that have a certain value. I've got close with this. https://www.extendoffice.com/documents/excel/3367-excel-extract-row-that-meet-criteria.html...
Hi,
I'm trying to automate the Facebook post in group - Even I'm almost completed but it is posting only the Text and not the link. When I input text it posts without any problem but when I input links it pops up with error message stating nothing entered in the text box (Autally I want the...
Good day. I run a Plant Hire company and deal with invoicing different clients every month. At times we have late paying clients and we need to add interest of 2% every second day of the month for everyday on late payment. I would like your assistance and teach me on how to calculate at 2%...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.