1111111111
1111111111
Last edited by John521520; 01-07-2022 at 05:35 AM.
When counting the number of times exist hour 7 (for example), is it for AM and PM ?
- Battle without fear gives no glory - Just try
What about Pivot Table: See attached
This may help: https://docs.microsoft.com/en-us/off...o-cells-change
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
sir i don not know too much about excel. i only want that whenever a new entry is done on column F. it should automatically update in column H and I.
See next code and new file attached
Please Login or Register to view this content.
Hi,
I want to make a update to the attached file.
I want to count no. of rows covered in minute instead of hour.
please make changes in the attached file for no. of rows covered in minutes
John,
As you did for hours can you what is the result you are expecting: A screen shot or Excel display
PCI
Hi,
for counting no. of rows in hour, it is working correctly.
Now i want that you change it such that it count no. of rows covered in minutes. please change the same pivot table so that it will start showing no. of rows covered in minutes.
here is the file attached for changing
Excel 2016 (Windows) 32 bitPlease Login or Register to view this content.
L M N O 1Minutes Hour Date Count 225 5 1/6/2022 8 326 5 1/6/2022 36 427 5 1/6/2022 38 528 5 1/6/2022 32 629 5 1/6/2022 41 730 5 1/6/2022 32 831 5 1/6/2022 24 932 5 1/6/2022 31 1033 5 1/6/2022 18 1134 5 1/6/2022 27 1235 5 1/6/2022 42 1336 5 1/6/2022 32 1400 12 12/30/1899 49638
Sheet: Sheet1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I don't know anything about coding and how to use it.
please make changes in the attached file and give me the edited file.
Thank a lot
(Please sir Reply to me)
I don't know anything about coding and how to use it.
please make changes in the attached file and give me the edited file.
Thank a lot
Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").
It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.
- Follow this link to learn how to install Power Query in Excel 2010 / 2013.
- Follow this link for an introduction to Power Query functionality.
- Follow this link for a video which demonstrates how to use Power Query code provided.
Hi Sir,
i have excel of version 2019.
Sir i only want that you provide me the file from which you showed the screenshot in reply no. #10 (please attach that file in the reply)
I am doing Mechanical Engineering. Currently i am doing a experiment to analyze the gearing system. From our project of gear system, we collect the data of its movement. We want such excel file to plot graphs for our understandings.
Currently i have no free time to learn power query. But as i have recognized its power, i will definitely learn this later in my free time.
But for now please give me the Excel file that you used for screenshot in reply#10.
Attached for your edification. Please update your profile to reflect that you are using 2019 and not 2016 as shown. When you ask for a PQ solution, one can only assume you know what to do with Mcode when supplied.
Last edited by alansidman; 01-07-2022 at 02:27 AM.
Administrative Note:
We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it had been only two hours since you last posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
Is file attached help you ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks