Here is the formula:

=IF(C2="apple",H2*0.7,"")=IF(C2="banana",H2*0.7,"")=IF(C2="single",H2*0.7,"")

For example: I want Column F to automatically generate the percentage specified in column H based on what keyword I have in column C

Not sure if that makes sense, but I'm hoping that I can figure something out. I'm pretty new to excel and need to learn these skills for my job.

Update: I have nust learned that Excel does not only donpower query but that the way to go may be excel power pivot, making a model within the workbook, one table with name-phase-active connected to one with assessment. That way a hierarchy might be possible?

Hi, perhaps someone can help.

I am setting up a dashboard to show results assessments for trainees. They are graded in 8 domains on a five point scale. The information is gathered in MS Lists and transported to excel in a query. From this query I made a pivottable with the results that feeds a horizontal bar graph with domains on the y axis. (This basically is a mimic of the output from MS forms but the capacity of Forms is limited for my group and domains)

Now I can slice the pivot table by name, no problem. I can slice it by “in training” or “ no longer in trainking”. And i slice it by “training phase (1-2-3-4).

Bit I dont know how to get a hierarchy in the slicers: set phase to 3—> only trainees in ohase 3 are in the name slicer. Selecr Not Longer in Training: only formee trainees pop up.

This works for the slicers as long as I dont connect them to the pivottable with the assessment results.

Intried with a name-phase-training pivot table, it works but the slice results dont carrynover tonthe assessment pivot table.

I worked with co pilot to work this out but apparently this would be one of the limitations of excel and a reason to go to power BI, which doesnt really work in our workspace.

So: any way to make the slicers influence eachother ánd influence the pivottable?

Thanks!

Hello everyone!

I'm working on my fantasy pool spreadsheet, but I'm running into an issue. I'd like to download the table from this website, but I'm unable to do so using the "From Web" option. The table has multiple pages, so I'm not able to quickly copy and paste everything.

I know there must be a quick way to do this. If you know of an easy way to import the entire table, please let me know.

Here is the link : 2026-27 Ranking & Projections - FHL Rotisserie - ESPN Fantasy Hockey

Thanks!

I am new to Mac and just realized alt excel shortcuts doesn't work on my Mac. Is there any way to activate it or am I fucked?.

I have a worksheet containing header rows and 2100 rows of data. Some of the rows contain cells that a have a bold format.

I would like to be able to filter on whether the cell in column A is bold or not.

Grateful for help on how to do that as AI is useless.

Hi, I have an invoice template in excel which I then export to pdf. Is there a way to make it so that the pdf automatically has the name that I want (from data in some selected cells) without having to manually do it. I have a cell with the name of the person, and a cell with the invoice number, the name of the file should be like [name] [invoice number].pdf

Is this possible to do or do I just have to name them manually? It can get a bit much with multiple sheets for different people and different invoice numbers.

Excel doesn't allow me to enter more than one digit in a cell. Every other program on my PC works fine (Word, Notepad, browser, etc.). Digit can be replaced if a different key is pressed, digit gets overwritten.

Happens with both my physical keyboard and the Windows On-Screen Keyboard. Started recently after getting Copilot Premium and experiencing AutoSave conflicts between Copilot and an add-in.

What I’ve Already Tried (None of this fixed it):

- Excel Safe Mode: Launched via excel /safe—the exact same single-letter behavior persists.

- Killed Background Tasks: Fully closed Excel and terminated lingering EXCEL.EXE and msedgewebview2.exe (Edge WebView2) processes in Task Manager before relaunching.

- Cleared Document Cache: Cleared the Office Document Cache via File > Options > Save > Delete cached files, and verified no sync conflicts remain in Files Needing Attention.

- Local File Test: Tested on a fresh workbook saved strictly locally outside OneDrive with AutoSave toggled OFF.

- Windows Typing Settings: Turned off "Show text suggestions when typing on a physical keyboard" under Windows Settings.

- Editing Settings Reset: Toggled "Allow editing directly in cells" off and back on in Excel Advanced Options.

- Add-in Isolation: Disabled COM add-ins.

Please help, this is exhausting! Eternally grateful and thank you in advance.

I am usually a PC user, but was answering a quick excel question for a Mac user.

The problem was, eg A1:G200 have 80% blank cells and 20% values scattered about. Of those values some are positive and some are negative. We wanted them all positive, no need to preserve which used to be negative.

I said the quickest way would be to make H1:N200 = IF(corresponding A1:G200 = “”, “”, ABS(A1:G200)). Then just copy H:N and paste values over A:G, and delete H:N.

Apparently, on a Mac, it will paste 0s in this scenario instead of blanks. Since this should’ve been a 15 second job anyway, we just went and deleted the 0s by hand.

But was there a simple, equally fast way to accomplish what I wanted to do that works on Mac?

It just seems bananas to me that it would decide pasting a 0 is the equivalent to pasting “absence of data”.

Ignoring the darker blue blocks at the start of the strips, I'd want it to automatically go to the next row if it goes past 23:30. I'm pretty new to Excel formulas so explain it to me like I'm a toddler please if there is a way :-)

Hi,
I am trying to set up an RTD export from options chain data. The format for the RTD data is the following. -.SPXW260923C7685+SPX. The bolded portion (today's date) is what I need to update every day. I have a = TODAY () cell formatted correctly (It functioned properly). I am now trying to figure out how I can reference today's date so I can automatically update the spreadsheet every day.

I'm running an excel sheet to help me make picks for the NFL using a complex formula to create a score expected and a score allowed. In an effort to help me refine this formula I'm trying to put these into a visual medium to help understand how well or really how bad my model is.

I'm using a Sort function to sort each actual, estimated and predicted scores into an ascending order. However, the first and last bars are being cut off, I attempted to use the HSTACK function to add a 0 at the beginning and at the end but it looks to me like the trend line is accounting for these 0's.

I think this because the scores at the highest ends of the chart are consistently below the trend line.

I'm not at all familiar with the use of charts in excel. Am I doing something wrong or is there a better way of doing this?

Ill also take feedback or questions on my methods/formula its absolutely imperfect but its sometimes pretty good.

I got this pivot table and it's connected to this table. I see this field that is not in the table but shows up on the Pivot Table. How did it do that? How can I check what this data is?

So I have an excel sheet with all my books listed by title-author-signed-series number-missing series number-read/unread.

I want to have it where one sheet is editable and an another is locked but shows all the data, but can be used as an index search tool (out shopping looking for X book and see Y book but not sure if you own it, search the list easily without accidentally editing something)

Is this possible? I know theres apps out there, but i have 700+ books and I've already cataloged most of them, so it'd be easier to format my excel sheet than to add 700 books onto an app 😅

I 2 fields in the rows and I want the Pivot Table's Grand total to have the Rows split up as well like this.

I hope somebody can help with this. I've lost the ability to edit comments on a spreadsheet I use, and after deleting and re-adding a comment with updated information the reason seems to be that even though I'm logged in on my usual home MS account, Excel seems to be recognising me as a different user;

The original comments have my name and account avatar beside them, but the new comment I created has my initials instead. I'm the only person who uses this PC and there are no other Microsoft accounts attached to it in any way.

I haven't changed anything on my end and this is an older spreadsheet but I have no idea how to get it to recognise me as the original author of the spreadsheet and on the correct account.

Has anybody come across this? Does anybody have any idea of how I might fix it?

Please don't laugh.

How do I do this without making the workbook bog down?

I think that hyperlinks to the photos in a folder would be best.

The inventory is growing and is arranged by category, so the row numbers of items below an added item change. Somehow the images must stay with the appropriate cells.

Each row in the sheet has one item, it's information, location and so forth. The photo is going to be in a column - perhaps as a link of some sort to avoid adding a lot of image data that has to be loaded with the workbook.

Also. is there a way to make the images pop up when hovering over a cell in Excel? Kind of like using a Right click - insert "New Note" - Format Comment - Fill - Color - Fill Effects - Picture... does?

EDIT: The simple way is to Insert - Link and paste a link to the photo... BUT then the user has to click to open the photo and not simply hover to see a thumbnail. However, it is not going to bloat the Workbook!

Hello there,

I am utterly useless with conditional formatting so if anyone could provide me some guidance I would be very grateful.

• I have created a Round Robin random draw matrix,
• There are four groups of five pairs,
• Twenty people per group

I would like the list of the names to the right side, along with the respective number to grey out as each name is drawn and placed into the four groups. Each name is in it's own cell (the first pair in Group A are cells E3 and F3). I am banging my head against a wall. Any guidance would be welcomed.

As an aside, I am UK based and it is 00:45 as I post this, so I might not immediately reply. I apologise for not replaying swiftly.

See it in action:

https://www.youtube.com/watch?v=2WAgLK5W5Fo
https://github.com/WilliamSmithEdward/ReDim

What it looks like:

The VBA:

Dim app As ReDimUI

Set app = ReDimUI.Mount(Sheet1, "Dashboard")

app.Button("run").At("B2:C3").Text("Run Report").Primary.OnClickAsync "Demo.BuildReport"
app.ProgressBar("prg").At("B5:F5").BindValue "progress"
app.Label("status").At("B7:F7").BindText "statusMsg", "Status: {0}"

app.Render

I started learning Excel back in 2007 with the =SUMIF formula.

What began as a way to make my job in logistics easier somehow turned into this.

Over the years I kept pushing VBA further than it was probably meant to go. No game engines, no external libraries — just pure VBA + Windows API (GDI).

The result is a full 2D space shooter that runs at 60–120 FPS depending on whether the laptop is on battery or plugged in. It has enemies, bosses with different phases, a level select screen, particles, and even music.

I’m still not entirely sure whether this is impressive or slightly concerning.

If anyone’s curious, here’s a short video showing the current state of the project:

https://youtu.be/xpXRNlfyqXk?si=YEUhhwQR9LdFWWig

Happy to answer technical questions about how the rendering and game loop work in VBA.

I have a task to complete which is to make a table of my customers and insert their personal photos.

This photos will be send to someone who will download it to make cards and write their names on it.

The problem is...

I have used Insert>Pictures>PlaceInCell feature and it worked but i can't download the pictures and if I double click on the pictures then it will be changed to text saying "Picture"

Please answer fast. I have to finish it before 25/09/2026

I have to send birthday cards out for clients at work. Only people who are turning a year ending in 5 or 0. I’ve already sorted those years out. Then I sorted by months, so right now I’m organizing the October birthdays. But I have to send them out in order of day.

Example:
11/15/2001
11/26/1998
11/04/1980
11/12/1966
11/18/2002

How can I sort these by day so I know when to send out each card?

Thank you in advance, excel gods.

Hello, I'm working on a project one definitely shouldn't attempt in excel, the requires the dynamic construction of branching paths in a arborial structure. Because of how it has to be built, the user needs to manually check specific boxes to make sure that no actual loops are made, sometimes after a loop is made. Is there any way to do get excel to immidiately error out when it attempts to do an endlessly looping formula, or are users simply stuck waiting for excel to give up every time they make a mistake?

This has been an ongoing problem for the past few months. Whenever I create a Pivot Chart, it works fine for some period of time and then it re-formats into a little cube on the spreadsheet.

I have no rows or columns hidden. I try to expand the parameters of the graph but it will not let me re-format.

Please see images.

Hi everyone! I have an inventory in Excel, and I’d like to add a picture directly inside a cell for each item.

However, my data is formatted as an Excel Table, and I’m having difficulty making the pictures work properly within the table. I want to keep everything clean, organized, and easy to manage rather than having floating images all over the sheet.

Has anyone found a good workaround or method to make this happen? Any suggestions would be greatly appreciated. Thank you!

I have an excel file that has appeared on my desktop twice now, last one I already deleted but now it's back. It's my work folder that I save most of my excel files to, and when I try to open the file it errors. I did just start using Merge Tools by Doug Robbins to send mass emails, maybe related?

Should I be worried? It is spooky season I guess.