Help Needed: Add Interactive Dashboard to Landowner Engagement Tracker (Same Sheet)
Hi all, I’ve built a basic Excel tracker to monitor engagement with landowners for a large infrastructure project. The purpose of the tracker is to: Show progress tracking of each case of for the project director to monitor progress help the Project Director Identify which cases may require statutory powers to secure access (if voluntary agreement isn’t possible) This helps our leadership team make informed decisions quickly. What I’ve got: A sheet called "LANDS RIGHT TRACKER" Columns include: Reference Number Agreement Status Case Status Risk Level (High/Medium/Low) Willingness to enter agreement Reason for refusal Flag for whether statutory powers may be needed 🛡️ All data is fictitious — names and details are placeholders, so no privacy concerns. What I need help with: my level of excel knowledge is very basic and I was hoping for some assistance to: Add an interactive dashboard and key metrics directly on the same sheet (not a separate worksheet). The below is just my suggestions as you are the expert your guidance expertise is much welcomed, happy for you to put it straight on to the tracker as I have left a section on the tracker for you to insert your items Ideally using a Pivot Table and Slicers to filter by: Case Status Risk Level Agreement Status Willingness to enter agreement https://docs.google.com/spreadsheets/d/1c2IJ-YLsTN-DZE9ltw0JR-nGVuuGzTKE/edit?usp=drivesdk&ouid=104511246399228274463&rtpof=true&sd=true
Data Import issue???
I am working on a drift formula for items being pushed by wind and waves on the water. I imported a text file of weather data, formatted all the data to numbers, and built an "if" formula to convert the wind direction into drift direction. Wind from 360 degrees (north) would cause an item to drift 180 degrees (south). The problem is the formula sees everything as false. Is this a formatting issue with the imported text? =IF(B28<180,B28+180,B28-180)
How to create a Date-Time Temperature Graph
Hi there, I was wondering if Excel is able to create a similar Date Time vs Temperature graph as shown, the green coded one? (the data was extracted from an app) I want to be able to show the Date AND Time on my Excel chart I have the raw number data but is unable to convert it into a graph similar to the one shown above, for reference the format of my raw data looks like this (below), but my raw data have three thousands results. Thank you in advance to anyone who can help me! - NonAutomate the function
Hi, I have a few thousand records of Course with ANZSIC allocation proportion. Is it possible to create an excel function to pick up the highest values within the same course whose difference of proportion with the next highest is within 0.1 and highlight it out? In this case, the first 3 records will be highlighted. Attached with an example for reference. coursecode coursename ANZSICDivisionDesc ANZSICDivisionCode ANZSICConcordanceProportion ABC123 Certificate III in Meat Processing (Food Services) Manufacturing C 0.45 ABC123 Certificate III in Meat Processing (Food Services) Retail Trade G 0.45 ABC123 Certificate III in Meat Processing (Food Services) Wholesale Trade F 0.1 BCD123 Certificate III in Meat Safety Inspection Manufacturing C 0.65 BCD123 Certificate III in Meat Safety Inspection Public Administration and Safety O 0.35 Regards EP
Power Query- filter Table by a keyword list, partial match
Hello, I have been looking for a solution for a while now to filter a table column with text (approx. 2000 rows) using a list (approx. 50) of keywords in Power Query. The list should be editable by the user in Excel and also contains partial words that I want to identify in the table. Texts in the table column are usually companies with different spellings, e.g. Amazon Germany, Amzn US, Bosch, Bsh, Glashuette, glashutte, Search terms: amazon, bsh, bosch, glash I have already found solutions for exact matches. Thank you very much for your help and the great work of the community. Best regards OliverHow to Be an Excel Detective: Finding and Highlighting Formulas
Hi everyone, I recently wrote a blog post on some simple, yet powerful, techniques for anyone who works with Excel spreadsheets, especially those with complex data. I wanted to share a summary of it with this community, as it might be helpful to others who are looking to understand and protect their work. The post covers two main things: Quickly Revealing All Formulas: A simple keyboard shortcut (Ctrl + `) or the "Show Formulas" option can instantly reveal all formulas in a worksheet. This is a great way to quickly see how a spreadsheet is structured. Permanently Highlighting Formulas: The article shows how to use the "Find & Select" > "Formulas" feature to select all cells containing formulas and then permanently highlight them with a fill color. This visual cue can help prevent accidental edits and protect your data. Watch This in Action: For a step-by-step guide on how to use these techniques, you can watch the video on my https://www.youtube.com/@BIGurus. 🔗 https://youtu.be/1x-1dbqlWXk You can also read the full article here: https://medium.com/@anandsharad/how-to-be-an-excel-detective-finding-and-highlighting-formulas-fe9d4fdbc1b1 I'd be happy to answer any questions you have or discuss other Excel tips and tricks in the comments!
REGEX+TEXTSPLIT
Dear Experts, I have a data like below in column"A":- And , I want to split it in the way like in "Yellow" So, after each consecutive Alphabet or number it should be splitted, I tried to do something in Column "B" but not succesful. Could you please share any solution if possible by using a comb of regex + textsplit? Thanks in Advance, Br, Anupam
