Forum Widgets
Latest Discussions
Adding Data Points to a Table or Chart After Power Query Refresh
I have an Excel workbook that has a worksheet for calculating who doesn't have access to our system based on content on the site. These calculations use XLOOKUP to compare two other workbooks (1 CSV and 1 XLSX). I then have Power Query clean up that sheet to generate a report. The CSV and XLSX are also cleaned up with Power Query prior to the calculations taking place. The output of the final report looks like this: I would like to know the total count of people, the unique count of people, the number of people who are the sole owners, the number of people who are listed with other people who do have access. As you can see behind the blur under "Triggered Owner", there can sometimes be more than one. The tricky part here is that I would like to track these numbers in a new row in a table for each refresh, similar to the below, where the data doesn't completely erase each time. Run Date is when the refresh occurs. Is this possible?renee_crozierMar 12, 2025Brass Contributor80Views0likes1CommentMultiple lookups from Data base information
looking for a method to lookup pallets, the data base has information entered by a form that includes shift and machine dataItemName values PL5 Shift 3rd PL4 Ending Partial Pallet / Paleta Parcial Final 9 PL4 Starting Partial Pallet / Primera Paleta Parcial PL5 Ending Partial Pallet / Paleta Parcial Final 0 PL5 Starting Partial Pallet / Primera Paleta Parcial 0 PL4 Finished Pallets / Paletas Totales 40 PL4 Shift 3rd my summary sheet is looking to match the date (easy) but need to include the lookup value of say PL5 shift value of 3rd, and provide the PL5 ending and starting partial pallets in different cells. I have been able to use xlookup to get all the other data needed but not the shift and pallet information. example xlookup(date&shift&line,table[date]& (this is where I run into an issue) any assistance is greatly appreciated.CarlM42Mar 12, 2025Copper Contributor60Views0likes2CommentsDynamic data validation based on another column in table
I'm trying to get the data validation (values from another table) dynamic, in a table and based on the value in another column. I manage to get all values from my other table in data validation using =INDIRECT("TableName[ColumnName]"). But I like to filter the values by the selection in the target table. I've asked ChatGPT, but it only leads me in circles - so now I hope for you super users in here! 😏Jake71Mar 12, 2025Copper Contributor10Views0likes0CommentsBeginner Illustrations to try my hands on
Hi community, I just joined to equip myself with Excel skills. I have gone through the Learn It beginner tutorial, and to practice on my own, I would be glad to have some illustrations to try my hands on them.Alfred_678Mar 12, 2025Copper Contributor32Views0likes2CommentsWrap an array which has two columns
I am using office 365 (family). I have an array output which is 27 rows long and two column wide. I am trying to wrap it dynamically say for eg. after the 13th row to be displayed in the forth and fifth column. I am able to do it with a single column [vector] output using index and sequence but not when it is more than one column [multiple column array]. Currently I am managing it with TAKE and DROP function. Obviously both the functions are entered in separate cells. Is there a work around to do it with a single cell formula without compromising on its dynamic capabilities without macros or VBA or power query.rprsridharMar 12, 2025Brass Contributor1.2KViews0likes5CommentsExcel VBA - Define Range of rows from known static range as start to flexible range address as end
Need help with an Excel VBA process. Below is a screenshot of the current logic with the intended goal noted in the red box. Can someone assist with helping me set criteria to define the range or rows between a static row (11 - aka RowStart) and one above a flexible end row, with the end row being determined by a cell match? Copy of file attached as well. Mod in question is "ModCreateNewUserTEST". All other Mods are working as intended and do not need changes.SolvedJoeCavasinMar 12, 2025Brass Contributor661Views0likes9CommentsParsing Issue
Dear Experts, I have a Data like below:- From this I have a to create an Output file with the below logic, (sample of an entry in Output file is below):- HARQ ID, can range from 0 ~15, and Each HARQ can be re-transmitted(RV) in the Sequence 0->2->3->1->0->2->3->1...(create data with all the Harq IDs having the RVs in a full cycle and extended(0-2-3-1-0) System frame number have to be consecutive and after 1023 SystemFrameNumber(Column C) repeats it self. Thanks in Advance, Br, Anupamanupambit1797Mar 11, 2025Iron Contributor129Views0likes2CommentsCalculation of values based on the next occurrence of a criteria
I am looking to create a formula to sum an amount between 2 rows based on the next occurrence if a criteria. in the below example. the criteria will be to look for "apple". my values are located in a table. between the 1 occurrence and next there is no amount values, hence the sum value needs to be 0. then between 2nd and 3rd occurrence the formula needs to sum all amount values for a,b,c,d,e. then between 3rd and 4th occurrence the formula needs to sum all amounts for a,b,c,d,e,f,g,h this continues down for the last sum 'block' it needs to sum the values from the last occurrence of "apple' to the end of the table Amount sum value apple 0 apple 25 a 5 b 3 c 2 d 10 e 5 apple 53 a 2 b 1 c 4 d 5 PLUM e 10 f 6 g 15 h 10 Apple 25 a 2 b 4 c 7 d 9 e 2 f 1 apple 19 a 5 b 8 c 3 d 1 e 2 f 7SolvedCBritsNZMar 11, 2025Copper Contributor83Views0likes3CommentsNeed Help! I can't Sort
Hi. I'm having trouble by sorting data (A to Z and Smallest to Largest). When i select data like this and then i click on Sort it doesn't work: When i Click on sort a, Progress Bar with the name "Sort:" appears and it doesn't work: I need help because i use Excel on my job and this problem makes it a lot harder.esp_benjaminMar 11, 2025Copper Contributor47Views0likes2Comments
Resources
Tags
- excel42,368 Topics
- Formulas and Functions24,568 Topics
- Macros and VBA6,371 Topics
- office 3655,971 Topics
- Excel on Mac2,629 Topics
- BI & Data Analysis2,351 Topics
- Excel for web1,896 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,618 Topics