Excel Formula Help
Hi everyone again, so I am trying to pull data from one tab (DATA) to another tab (MRD ABC123, SLRD ABC123, etc..) there are examples in the first 2 tabs (MRD & SLRD ABC123) of how i am trying to pull this data over. I have tried formulas and have had some help on here as well to try some formulas but nothing is wanting to work. The data on the DATA tab is being copied and pasted from a Microsoft Forms. the columns i want to transfer the data to their perspective tabs is in Orange (Column F - R) Any help on this would be greatly appreciated. I have attached the spreadsheet below
MS Excell application for Client database working under Windows XP.
Hi all, In my company we have a MS Excell application for Client database working under Windows XP. For Windows 10 it wrks now under a virtual box. I want it to work with Windows 11! How is the best and efficient way to do that? Hope someone can help me out. Thanks for cooperating. Eric
Suggestion: Add =IMAGE() function to Excel 2016 & 2019
Hi Microsoft Team, I’m an Excel 2016 user and really appreciate the product. However, I’ve noticed that the =IMAGE() function is available only in Microsoft 365 and the web version. Many of us who are using perpetual versions (Excel 2016 / 2019) would love to see this function back-ported. It’s a small but powerful feature that makes dashboards, catalogs, and reports much more useful. Not everyone can move to 365, but we still look up to Excel for improvements. Adding =IMAGE() to 2016 and 2019 via update would make these versions more practical and user-friendly. Please consider including this in a future update. Thanks for listening and for continuing to improve Excel!
Finding Possible Matches to a Solution
Hello Everyone, I'm wondering if anyone has any tricks or formulas that I can use to find any possible combination of numbers that will create the desired solutions I'm looking for. Take a look at the picture I uploaded for reference. If I have a list of data in column A, I will be looking for a given set of numbers that will create a sum that matches column C. I'm looking for a trick or formula that will return all possible combination of numbers that will sum up to equal Column C and then return those possible combinations in another column for me to see (for example like what you see in columns E, F, & G). Does anyone have any ideas on how or if this can be done? I would like to do this without the use of complicated macros or other codes if possible.I need to learn how to use the LET function in Excel...
Hello Excellers, I am using a complex If statement to figure out if a machine is ready to receive work. I need to check if the machine is online, or broken down, or off line for some reason or another, Has a Human worker to work on the machine, and on and on... I am thinking would a LET function help in making the IF function more accurate, and less complicated? I have not worked with the LET function, and I think I would like to learn about it. Any nice resources for examples and tutorials? Thanks in Advance! GiGi!
Excel help requested
Hi folks I am new to the forum but have been an Excel user for a good few years. I would appreciate some advice from experts. I have a spreadsheet with several worksheets on it. The first being the entries from bank statements. I would like to have the entries on this sheet automatically added to the respective worksheet as each company my Masonic lodge uses has a separate worksheet. For example gas etc. I’ve tried to attach the sheet but it doesn’t appear to be possible. Thank you in advance. steve
Excel Formula
Hi, I'm trying to figure out which formula (if any) to use in my workbook to make it more automated. I am needing to have a formula in worksheet 4, that will go to worksheet 1, locate the word "Thursday" in column B and return the corresponding date listed in column A. For more context, worksheet 1 has information for daily testing and worksheet 4 is a report that requires specific information for Thursdays only. I've been able to automate everything except for pulling the dates from worksheet 1. I've tried VLOOKUP, XLOOKUP, IF, IFS and I just can't figure it out, as well as spending many hours trying to research which formula(s) to use. Please let me know if more information is needed.Excel Formula Help
Hi everyone, i am needing help pulling data from one sheet to another. The "DATA" tab is a bunch of data that is pulled from a Microsoft forms survey and i copy and paste it in the sheet. Once i copy and past the data i want all the other sheets to pull this data into its perspective tab. On the "DATA" tab in coloumn G is the district and each district has a different column for the module. So MRD districts module is column I, SLRD districts module is Column J, SBRD districts module is column K and so on. What i would is when data is pasted i want MRD ABC123 to pull the data from the "DATA" sheet onto this tab but it has to meet the 2 criterias. 1st criteria for the "MRD ABC123" tab is the Job Code in Column F on the "DATA" tab has to match ABC123 and the District column G in the "DATA" tab has to match MRD and then pull that data from the row on the "DATA" tab into the perspective columns on the "MRD ABC123" tab. Im just looking for a formula that will work for each column on the "MRD ABC123" tab to pull the data from the "DATA" tab. i have tried Index Match, Xlookup, and Filter functions but i know im doing something wrong. Any help would be amazing. thank you.
XLOOKUP returning #N/A for some values when the values are there
I am trying to use XLOOKUP to find an identifying number from a separate spreadsheet, referenced by a different identifying number. My equation works for the most part, but I have a few #N/A errors (3 out of 11), but I have confirmed that the values were present in the array and that there were no typos. I cannot share a screenshot, so I will give a simplified version using sheets WS1, WS2, and WS3 with values ID1 and ID2. WS1 is the active sheet I am writing the formula in ID1 =VLOOKUP(A2,WS2,ID1Column,false (This equation works with no issues) ID2 = XLOOKUP(ID1Value,WS2LookupArray,WS2ReturnArray) ID2 equation works for the majority of the time, but returns a few #N/A and I cannot figure out why. I have run trim to eliminate any extra spaces, I formatted all cells the same way, I have no idea why I cannot get the error cells to work.How 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!
