krunal123

Board Regular
Joined
Jun 26, 2020
Messages
177
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
image_2021-04-11_120225.png
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
What does your Mcode show. Difficult to evaluate issue from a picture. There is nothing obvious.
 
Upvote 0
i try Show PARTY/ STATE/ COUNTRY TABLE SHOW in POWER QUERY EDITOR...........
 
Upvote 0
Post your Mcode so that it can be analyzed. Pictures cannot be analyzed for the steps taken. In the Editor, click on View-->Advanced Editor and copy the Mcode and paste it into this thread.
 
Upvote 0
You have three separate tables with no obvious link between them. If the rows in each are related, why are they separate tables?
 
Upvote 0
Rory,
May I borrow your crystal ball. How did you determine that there were three tables? I did not see that!!

Alan
 
Upvote 0
If you look at the bottom right corner of the last cell in each column, you can just see the little blue table extender handle. :)
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

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.
Go back
Back
Top