Hi everyone!
I am new here in the forum and I looked for some solution to my problem and I did not find anything similar, so I decided to create a new post.
I have a workbook with two worksheets "STOCK" and "SALES REGISTRATION".
In Stock, I give all of my products that I buy to sell...
Hi
Trying to create formula foe the below table which has multiple criteria x Qty x Duration (with two dates)
Attached sample file: Eg for Apple. Same as vlookup to be made for all items like carrot, beans, tv from nested cells.
After this, the results will be converted to Pivot table /...
Hi, I have a multi sheets tab in a workbook as you can see the name of sheets . i want when i click on the sheet name of any one the data show me of that sheet . than i can sort out by Last name as showing " Braaf "... Many Thanks
A Column
<tbody>
Sheets Name
HV-Agewell beg...
Hi there,
I just wanted to fix the following problem that last few days struck my work.
Data:
<tbody>
A
B
C
D
E
F
G
H
I
J
K
1
10/5/2016
RAM
10/5/2016
RAM
RAHIM
SUJA
0
0
0
0
2
10/5/2016
RAHIM
10/6/2016
RAM
RAHIM
SUJA
SANGEETHA
0
0
0
3
10/5/2016
SUJA
10/10/2016
RAM
RAHIM
SUJA...
I created an array formula in PC excel 2010, but a MAC user is not able to see the results of the formula.
see below for the MAC's screenshot.
https://dl.dropboxusercontent.com/u/52990313/Array%20Image.TIF
cell D2 is blank when there should be a result from the formula.
auto calc in MAC...
Hi,
I need to find out how to do this for work and I've been trying various things for the last 45 minutes to no avail. :( In this small example, I have a data table and a separate lookup table beside it. I want the lookup table to return values from the data table. The last columns value (G...
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.