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?
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
264 nested IF statements -- alternative?
Apologies if this is a duplicate entry. I can't seem to find what I thought I posted earlier. I'm looking for alternatives to using LOOKUP when there are numerous nested IF statements. Please see attachment with a screen shot of part of my data. I have 264 individual tables of data based on specific characteristics (age, education, etc.). Each table has 2 columns: score X, score Y. I'd like to be able to pull the t-score (right column) based on the scaled score (left column) depending on the characteristics I select. For example, if A1 is someone's age and B2 is someone's years of education, etc, I'd like to pull the data from the table that matches those characteristics. If I had only a handful of tables, I could use something like: =IF(AND(A1<34,B2<9 [etc. for other characteristics]),LOOKUP(D2:E21),IF(AND(A1<40,B2<9 [etc. for other characteristics]),LOOKUP(H2:I21), .... however, I know this will not work because I have 264 different tables/combinations of characteristics. Appreciate any recommendations. Thank you!
Help with XLOOKUP
=XLOOKUP([@Name],'[May 2025 Metrics.xlsx]Individual Tech Summary'!$A:$A,'[May 2025 Metrics.xlsx]Individual Tech Summary'!$D:$D) Let me say thanks in advance for any help with this. I have to pull numbers for each of my technicians into a spreadsheet from multiple excel files that are sent each month. I muddled through a few web pages on XLOOKUP and was able to get the above to work. The screenshot is just a snip-it of the file I'm working in, and it goes out to column U with all the various categories (nothing crazy). Since I have to do this for monthly reports and the quarterly report, I have the same little snip it copied 4 times on the same worksheet (tab?). It's one thing to have to set this up once copying the above formula and just having to change what destination column is referenced "!$D:$D", but having to change the destination file name twice for each column that is using this formula is killing me as the file names are always changing. Is there a way I can modify this to use a cell reference to somewhat automate this? I would like to be able to type in the file name into say cell D2 and it use that to complete the formula. Example: =XLOOKUP([@Name],'[D2]Individual Tech Summary'!$A:$A,'[D2]Individual Tech Summary'!$D:$D) and on cell D2 it would have either "[May 2025 Metrics.xlsx]" or "May 2025 Metrics.xlsx". I hope this makes sense? That way I can just update the name for June 2025, July 2025, Q3 2025, Q4 2025, March 2029... you get the idea I hope.
YTD Dynamic Calculation
Hi, I want a help to calculate YTD dynamically in which it should always start calculate from January month only no matter January month falls in which cell or column in a provided range (here i want the solution in automatic manner in which i don't need to increase/decrease any range) Thanks in advance 🙂
