Hello,
I don't understand why xlookup refuse to work (see attached). I imagine I do something wrong but I don't see it. Any idea ? I tried on a new sheet a simple request to see if it's not a format issue but unfortunately not. Vlookup is working. Thank you in advance.
Hello ! Hope you're all good !
I try to use the "VLOOKUP" function (alias "recherchev", i work in french for the moment) to show the name of the 1st and 2nd person who have most points of the "POULE 1". In this case, "Participant 25" and "Participant 26".
But it does'nt work and it's the last thing i have to do... what am i supposed to put in the first fonction ?
I work in the 2016 version on Windows 11. I'm a beginner so i still have some difficulties ^^'
Note : Faux = false in french
Thanks in advance !!
I maintain a tracker sheet where each row is a document (status, current revision, dates, owner, etc.). Rows get updated a lot, sometimes by hand, sometimes by a script that writes into the sheet.
What I want: for any given row, be able to click it and pull up that row's previous versions, and pick an earlier one from a dropdown (to view what it looked like before, and ideally roll a cell back). So the dropdown for row 12 shows only row 12's history, row 40 shows only row 40's, and so on.
Any one has done it? Or do I need to use sheets script for this?
This is a long shot, but I am an excel amateur currently trying to build an opportunity cost spreadsheet to find out whether or not it would make sense to go back to school for an engineering degree to hopefully put myself in a career path with higher earnings and growth potential vs my current blue collar path. I wanted to check in here first to see if anyone has done something similar as all things I would like to include are making it a decently complicated spreadsheet (for me). It’s main purpose would be to determine at what wage would I have to make now at my current job to where going back to school would be a moot point, and if that wage is possible to achieve in my current career. There are other intangible benefits that would come with going to back to school/having a career with greater flexibility, but I’m not super concerned about attempting to add that at the moment.
I know enough about myself to know I’d have to commit to school full time to make this work, so I’d like to factor in the following:
- Loss in wages/401k match/healthcare benefits during years going back to school
- 401k compounding growth comparison that includes company match between current job and average wages of the higher paying career. This would be two different models where the higher paying job match would compound for a slightly shorter length of time to account for the time it took to go back to school
- Cost of schooling lump sum invested at compounding growth until retirement vs using it for school
- An employee stock purchase plan max contribution comparison over length of career
There‘s probably some factors I’m forgetting at the moment, but I think the idea is somewhat clear. Again, this is a long shot, but any help is appreciated as otherwise I will be at this for a bit lol.
I'm a complete excel amateur. Can't work this out, have looked up videos but no luck.
I'm looking for a clean and simple Excel spreadsheet to track my daily supplements and pills. Ideally, I'd like something with daily checkboxes and maybe an inventory section to keep track of how many supplements I have left.
If anyone has a template they're willing to share, I'd really appreciate it. Thanks!
Excel Version: Windows 7
I am working on a sheet that, to put it together, requires the use of Autofill to drag multiple formulas downward. I want to know, rather than the current situation I am in:
(The selected tile has been autofilled by dragging the top three tiles down, as shown below: The first tile's value was =$A1, as shown on the image underneath the below one)
The values are to only increase by 1 no matter what happens.
...Like this!
Happy 4th!
I am currently facing an issue, where I need data I receive in one cell, in the form of two names separated by a hyphen, separated into two different cells.
I.E. Cell 1 (Alabama - Montgomery) >>> Cell 2 (Alabama) Cell 3 (Montgomery)
Any tips? I receive hundreds of these cells and manually separating it in a notepad seems not very efficient.
Thanks!
This is nervewracking- and I apologize in advance for the lengthy post!
I'm a chef at a concert venue, with a background in computers, who has very basic actual Excel skills. I've pushed myself time and time again to learn how to turn the data from our food sales into something I can utilize for food prep and ordering- and over the past few years I've built something that works well for what we need.
The workbook I use now has a 'Master' sheet with a column for each show, and a row for each different item we sell. There's a sheet for each show which I populate manually from a Square report that I quickly clean, organize, and copy/paste- the only other thing I do on these sheets is input the total number of attendance and sum the total revenue.
The show columns on the master sheet use a VLOOKUP to pull the item sales data from each show sheet- this combined data is what gives me the 'Item Sales Per 1k Guests' which is the most helpful piece of information and the real purpose for this post.
Our GM is leaving- and I think I want to push for the position. He is only around for 12 more days and then potentially supporting in a consulting role for another week or two after that. Somebody has to very quickly gain an understanding of the beverage sales and ordering volume.
I've tried just turning my workbook into a beverage workbook but quickly ran into a problem- we sell the same beers in different sizes ('Item Variations'). My food sales formula won't work- so I decided to turn to the internet to investigate a different formula/option and hopefully learn even more about Excel which is honestly something I love.
Everything pointed to Power Query and Pivot Tables, so I learned as much as I could and have now figured out how to pull a full food and beverage item sales report from square, drop it into a folder, refresh data in the new workbook and see the sales update in Excel. Neat.
The problem is I don't know how to turn this automatic data import into a clean 'sales per 1k guests' number on the dashboard sheet with the pivot table and slicer.
So the question is: What is the cleanest way to populate the dashboard sheet with item sales per 1k guests for each of our items sold?
AI has me going down multiple different methods of even getting the square reports into the workbook- and can't stop making suggestions that aren't relevant to my actual end goal.
Should I just keep on with the Power Query imports and manually adding attendance from a table on a separate sheet? If so, what do I need to use in the 'Values' section of the Pivot Table. Ideally, this workbook should scale with each shows report import and provide a very clean and simple number that lets me wrap my head around how much of each item to plan on selling for a determined number of incoming guests.
Additionally, this is something that should be scalable because I will turn into a few other tools: one that takes a quick on-hand count sheet and compares it against what we've ordered in total so far (with the guest attendance we've served so far) to determine how much to order for any desired amount of people (usually 20,000 people or so). I also want to turn it into a prep calculator based on projected incoming guests, using the 'Item Sales Per 1k Guests' and the recipe requirements for each of those items. That will come down the road, I just don't want to cut myself off from building these.
If this is too broad, I can provide whatever I need to from what I have built so far- but I'm hoping this community can help point me in the right direction for building this foundation.
Im trying hard to figure out how to write the formula of this graph. I think it's something like y= -2784.7*x^5+48644*x^4-335399*x^3+(10^6)x^2-(2*10^6)x+(10^6), but whenever I input any of the x values of the chart into the formula it gives me an x value wayyyyyyy too small. Any help would be appreciated.
Using Excel365 and I’ve figured out how to change the color of a cell when one checkbox is marked TRUE or FALSE, but how to I get it to changed if multiple checkboxes are marked TRUE?
In the 2019-2021 era I worked as an independent technology consultant and a significant amount of my work boiled down to transforming excel models and systems into web apps or desktop apps.
In the era of vibe coding and replit/lovable/Base 44 app builders, do companies and institutions still use excel as a medium for prototyping?
First off, I am an amateur when it comes to excel.
I am organizing my postage stamp collection on excel and have thousands of images that correspond to each individual stamp. I initially tried hyperlinking each image, but found that they get all mixed up, or lost all together. I am not good at formula's, but found some online, but could not get them to work. My best success (so far) has been using the "place in cell" function, and my question is this: how can I permanently make the image larger when using ctrl+shift+F5?
Note: I am looking for solutions that are compatible with Excel 2007.
I have the following setup:
Entry cell for region: V36. (Example text entered: Hawaii)
| Row | Name (Column B) | Region (Column C) | .... | Region (Column V) |
|---|---|---|---|---|
| 39 | Zeke | Hawaii | * Yes | |
| 40 | Dixie | Okinawa | * | |
| 41 | Hopper | Hawaii | * Yes |
The Names (B) and Regions (C) are fixed data.
The entry cell for regions (V36) is a cell where I can manually enter a region's exact name (such as Hawaii or Okinawa).
The second Region (V) column checks if the person in each row matches what's in the entry cell. The column cells contain the following formula:
=IF( AND(V$36=$C39; NOT(V$36="") );"Yes";"")
Basically, if the regions match and the entry cell is not empty, Yes is displayed. Otherwise, the cell is empty.
-----
Now comes the complication: It was introduced that one person can belong to two regions.
I see multiple ways to change the raw data:
(I lean towards option #1 in case an idea comes in the future that people can also belong to more than 2 regions. But for now, let's assume that the maximum region is 2 for everyone.)
-----
QUESTION: How does the formula for the second Region (V) column change with each option?
The original formula: =IF( AND(V$36=$C39; NOT(V$36="") );"Yes";"")
The two options:
Edit 1 (2026.07.04): Removed irrelevant data.
Edit 2 (2026.07.04): Excel 2007 limitation.
I'm trying to build a reporting dashboard to take information and show different metrics about that information. It's an obvious job for slicers and pivot tables but I'm having trouble figuring out how to handle issues from multiple items appearing in each column. Data is coming in from MS forms, which does affect the input options.
This is a good representation of my issue. Obviously categories and names are made up.
| saleman | type | equpiment | hours |
|---|---|---|---|
| Alice | cookies;cakes | mixer | 3 |
| Bob;Charlie | candy;cookies | oven;stove | 2 |
| Alice;Charlie | cakes;candy | mixer;oven | 4 |
There are reasons to want to track the number of hours a salesman is associated with. But also the number of hours associated with equipment, etc.
I'm fairly comfortable with using queries to split on delimiter, unpivot those generated columns, etc. then pivoting back around to get hours associated with each salesman, or each type, or equipment. I'd like to have a pivot table for each category, and also slicers to cut on each.
All of the examples I can find online work when there's one item per column, or at worst multiple in a single column. Is there a best guide somewhere on how to handle this or at least better terms to search for? Thanks.
Hello all, so I'm trying to organize my library. I have my books and a barcode scanner. Is there a way I can scan the ISBN barcode so it fills out the public info in the yellow cells?
Hi Great people , am trying to sum cells on a filter column e.g SUM(A5,A12,A20,A31) however when removing the filter the sum picks the whole column instead of the picked cells above , will truly appreciate your help with this.
Hey all! Apologies in advance if this doesn’t make sense, but I have 0 skills and figuring out how to do this would help me out a lot. I am trying to either create a new array or edit this one with a time calculation. The thing that I’m specifically confused about is how to run a different calculation based on the letter in the 2nd column. Say this is the array:
01:22 K
0:39 K
0:39 C
0:00 U
The calculation would assign new times to each line based on the letter and how much the total time has reduced by. So the total shown above is 2 hours and 40 minutes, but say I wanted to reduce it by 1 hour (it will always be a reduction of time) so I want to generate a new array with a new breakdown that now totals 1 hour and 40 minutes. The tricky part is that the time is reduced differently depending on the letter. U gets reduced first, then C, then any remaining time is evenly divided by each K.
So the full 39 mins would be removed from the C, and then the remaining 21 minutes is divided by the 2 K lines. Obviously that doesn’t evenly divide, so 1 would reduce by 11 minutes and 1 would reduce by 10 minutes - it does not matter which one is reduced by which amount, so long as they are as even as possible. Must be whole numbers.
The new array would show 1:11 K, 29 K, 0 C, 0 U.
If U had a value though, say 21 for the sake of easy math, the U and C would become 0 and the Ks would remain as is. If U had a value of 1:00, just the U would become 0 and everything else would remain as is.
Hopefully that makes sense and thank you so much in advance for any insight you can provide. 😊
Hi guys,
I'm not the best at Excel and have found something that I can't figure out.
Basically I'm trying to make it possible for a value to entered into one cell eg B2, then check a table for that value and after finding the value increment the number in the cell next to it (found in cell a12, add 1 to cell b12).
Even if you guys just tell me Excel won't work for what I'm trying, that will be a help to be. I'm just unsure how to make it work the way I'm trying to.
Thanks in advance for any help :)
I am trying to copy information from a website and paste it into an excel cell, but it is putting some of the sentences into one cell and other sentences into the cell below it. I can't seem to fix that. Does anyone have any suggestions? Thank you!
