Conditional formatting - new rule based on two related column headings
Need to create a new rule that changes cell colors (column H) based on more than 2 falls (column C) in 30 days for the same person (column A). I've found the formula for just the date - but not for adding in the same name. Goal is to be alerted (visual alert) if someone fell more than 2 times in 30 days. Thanks!
Cubeset with multiple Period range
Hey All! need help with creating a Cubeset formula! I've market data at region level for multiple period & brand! I want to know the rank of particular Brand in each region on Specific Period. Formula is working for a particular period but not working on a range! How can I use a range/dynamic period in cubeset. =CUBESET( "ThisWorkbookDataModel", "EXISTS([Brandmaster].[Brand].children, ([State_Master].[State].[Maharashtra], {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))", "Set", 2, "{([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]})}" ) This is working for particular month but when I want to get data for 3 month like Oct-Dec =CUBESET( "ThisWorkbookDataModel", "EXISTS([Brandmaster].[Brand].children, ([State_Master].[State].[Maharashtra], {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))", "Set", 2, "{([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[dec-2024]})}" ) I'm getting error on this. Range is working on set expression but while using same in Sort By (Highlighted Part), I'm getting the error. One way around is passing Each Month separately not tried that but I want it to be dynamic using timeline & using Min/Max function to define the range, it could be 2month or 12 month. Pls help me with this. Thanks
Index & Match formula not working on multiple column
https://onedrive.live.com/personal/8419718c3ad8f98c/_layouts/15/Doc.aspx?resid=8419718C3AD8F98C!s94600d3fa0044d418fefd1508e44c0e2&cid=8419718C3AD8F98C&migratedtospo=true&app=Excel Hi Folks, I'm facing error on the match formula, which I tried to apply, I'm getting #N/A error... I tried few trouble shoots to make it work (adding helper column, broke the formula with "&" to make it work, checking for any additional characters & checking the format etc) but it is not working. I have used Match formula earlier, but never had this issue. I want a single formula to MATCH & verify multiple column to return the desired output, I can do single column verification & again to do the next column verification and get the result but it is tedious and not time saving. Kindly help me to learn how to make a formula work to one validation of multiple column. Kindly attaching the sheet above for reference. Highlighted the error in yellow hue(Sheet name - result). m_tarler & HansVogelaar - Please help, Thanks in advanceIndex & Match formula not working on multiple column
Hi Folks, I'm facing error on the match formula, which I tried to apply, I'm getting #N/A error... I tried few trouble shoots to make it work (adding helper column, broke the formula with "&" to make it work, checking for any additional characters & checking the format etc) but it is not working. I have used Match formula earlier, but never had this issue. I want a single formula to MATCH & verify multiple column to return the desired output, I can do single column verification & again to do the next column verification and get the result but it is tedious and not time saving. Kindly help me to learn how to make a formula work to one validation of multiple column. Kindly attaching the sheet for reference
Get ISIN Number from Company name and vice versa
I have an Excel sheet with over 300 US companies and their ISIN Numbers listed at the stock market which I have to verify. Is there anyway to get the ISIN Number using the companies name or vice versa. That way I don‘t have to manually google each company and compare the ISIN numbers. Kind Regards.
Filter and Sequence Function
Dear Experts, I have a Data like below:- The Column"D" can have the values from 1..5 but in Sequence only, I need to filter only the ones where this txNumber is starting from 1 but ending >1 So, all the entries where we have the seq- 1..2, 1..3,1..4,1...5, but not 1...1 , that means no Retransmission txNumber=1 is always a New-Tx, now I did it manually one by one.. but eats a lot of time How to do such grouping by a Formula. Thanks in Advance, Br, AnupamUsing Target Data from another Sheet to link to Power Query Data
Hi all, I'm building a training dashboard and have used Power Query to pull through the data that comes directly from the learning system. I can show how many units each person, and then each department has completed. However, Different Departments, and then divisions within those departments have different mandatory competencies. I have these set up in another sheet in my workbook as a course database. I've set it up for Course - Tier (Mandatory or not) - Department - Division. So this table shows how many mandatory units each department must complete. My issue when trying to create relationships in that there are duplicates, as some departments have a number of the same courses. Everything else is working ok - but I need to show how many courses have been completed vs the amount of courses they need to complete each year, and in case this changes over the year (for instance if we add a new course) I want that to be dynamic instead of just saying "out of 18" for instance. Can anyone provide any guidance? I'd greatly appreciate it!
How do I weigh ranking based on value size
Hi All Im trying to rank some numbers in excel and it works fine so far. However it is not depicting differences between values as i would like: Ranked table is on top with the following formula: =RANK(C17;$C$17:$C$23;1) / =RANK(D17;$D$17:$D$23;1) onboardings ranking 7 6 5 4 1 3 2 onboardings data 1013 248 222 139 14 51 46 Now as you can see it ranks just fine, but the difference between the highest in onboardings ranking (7) and the next highest (6) is just marginal. I would like the formula to be able to give some space in between, maybe say more like 8 or 9 and skip in between. How can i define the Rank starting at 10 and be variable in between? Thanks for the helpPower Query Combine Worksheet
Dear Experts, I have many sheets(>10) sharing only 2 here as an example. Each sheet has a data summary in the end as below, and I want to merge all the sheets into a Single one with all the below data only:- But when , I merge the sheets, in the Column "A", only Time is there but all the stats are gone and not merged:- And after merge all that needed data is lost, and only Time stamps are there:- What wrong , am I doing here? Br, Anupam
