Text Extract - 2
Dear Experts, I have a txt file as attached in Excel, from where need to extract the meaningful data like below(Logic and what to extract is like below) Each cell Identity has a MeasQuantityresults for rsrp,rsrq and sinr, followed by the rsrp,rsrq and sinr for ssbIndex for the same cellIdentity as below till a new cellIdentity is measured and so on.. :- By the way , if someone can educate also on what format would these(txt) be? in what language do we use these nested kind of pattern.. any easier method to read them ? Any PQ or legacy formula Welcomed ... as I don't have REGRX in my excel , but I do have Python supported in my excel version, so regex in python also more than Welcome to achieve the output. Thanks in Advance!! Br, Anupam
Formula 4 week rotation excluding Fridays and weekends
Hi. I'm creating an employee work calendar. I need to formulas. One i have it but the other one i cannot figure it out. Employee A works from home, called W, one day a week. Week 1 on a monday, week 2 on a tuesday, week 3 on a wednesday, week 4 on a thursday, week 5 on a monday and so on. Fridays not available and saturdays and sunday are weekends. My formula only works if the first of the month is a monday. So i cannot do another month plus i cannot figure it out for employee B when the working from home is a Tuesday for week 1, can someone tell me what i'm doing wrong?REF Broken Formula Link Issue
Hello! I have created 6x files which contain formulas that link back to a specific cell from multiple external files all stored in the same drive. However, when opening each of these files, either half or all linking to external files break and become #REF erasing the formula that links to the external sheet. Strangely, this doesn't happen consistently as sometimes only half of the links break across some or all files, sometimes all of them, and a mix of working and broken links in the same files. I'm not sure why this is happening and am finding it difficult to troubleshoot. Has anyone experienced this before or know why this might be occurring? Any insight or help would be greatly appreciated! Thank you!
Trying to search for multiple criteria and return multiple results
Hi everyone! I've got a hang up that's easy in my head, but I just can't find the right formula to make it happen. I work in catering and I'm trying to make a sheet that would allow us to search through our menu items for allergens more easily. I currently have a spreadsheet built that lists each menu item we offer, if it's vegetarian or vegan, if it's gluten free, and every allergen it contains (don't ask how long this took). I've attached a screenshot of the mock up version I've been messing around with. Ideally, I would like to be able to select the allergens I want to search for in the green drop down menu boxes, and have the full list of compliant items populate down from the gray cells. So far I've been able to pull a list of each allergen individually, but if a guest has a soy, dairy, nuts and legumes, and a shellfish allergy, it would be nice to be able to pull one cohesive list. Maybe a further stretch, but my wish list for this sheet also involves some way to search "vegetarian" and have ALL of the vegetarian food populate, not just the vegetarian food that isn't vegan. Here are the best potential solutions I've tried so far. If any of these can be tweaked and I missed it, please let me know: I can get XLOOKUP to search for multiple criteria with =XLOOKUP(1,(C3:C9=K6)*(D3:D9=K7),B4:B9,"none"), but then each drop down box had to be assigned a specific allergen, which kind of defeats the point of a drop down list. When I tried to give the lookup array a range that covered two columns, it yelled at me. FILTER worked fine when I was trying to search the entire sheet for one allergen at a time, but I couldn't find a way to make look for the crossover between two allergens when I wanted to refine the search. I tried: =FILTER(B4:G9,(C4:G9=K7),"none") I'm open to any and every solution! I'll try to stay on top of this post if I can answer any clarifying questions. Appreciate the help!Returning blank if equal cell value is found
If the value in cell A1 is found in the array D4:D4, I want the cell C1 to be blank. But if the value in cell A1 isn't found in the array D4:D4, I want the cell C1 to print the value of cell A1. However, the cells adjacent to the array automatically ''joins'' the formula and the input becomes grey. What I want: What I write: What I get (with the automatic input in cell C2, C3, and C4 in grey): Anyone who could help?
Problems with a SUMIFS formula
I'm really having some trouble with Excel in that it's not behaving logically. Essentially, what I'm trying to do is conditional sums for spending categorizations. But when I use the formula, I get an error that I can't figure out, because when I use the Function Wizard, it seems to work nicely. But yet, it comes up with this error, and I can't find any information sufficient enough to solve this. Here is the formula: =SUMIFS(B2+H4:H15,H4:H15,"Netspend Account",C2,"Netspend Account")
nested xlookup
Hello My input data is my desired output is how to achieve this result, basically, i need to get the values for whatever date i enter in the column header. it needs to pull the values corresponding to input table. i tried using nested xlookup. please guide me. PS: i need to use in webexcel (excel 365) Thanks Kalyan,
