Custom number formatting help
Hello, I need some help/advice for displaying a value. Im scaling large recipe amounts, and at some point it'll become cumbersome to do '112 tbsps' and I'd prefer it read '7cups' after a threshold. Ive got a lot happening in an office script that I've made and Ideally I'd like to avoid further complicating the core formula of these cells. So I was looking at number formatting as a possible solution. However, Im struggling to figure out if its possible. Right now I can obviously check for the thresholds, but the formatting itself doesn't seem to do any of the actual math. For example [>=32] #/16 "cup(s)";# ?/? "tbsp" just returns 1792/16 cup(s). Rather than divide the value, it scales it up by 16 which is... confusing. Could someone tell me what I'm missing? Or am I looking in the wrong direction here trying to use the number formatting and instead I should work in the CONVERT function into my cell formula? I'm hoping to avoid that, so I thought I'd ask for help. Thanks!
Using filter to populate cells from the bottom up.
I am using filter to populate calendar day cells from the top down, but would like to populate from the bottom up (see below), but would rather fill the cells in from the bottom up. A calendar day cell is illustrated below. the current formula is: =FILTER(Dates!$H$4:$H$37,Dates!$G$4:$G$37=DAY(H9),"") Where: Dates is a tab with the dates and tasks to be shown G - is the day number part, I.e. 10 H - is the text to be displayed, i.e. April Fool’s Day (n this tab H9 is the date value where DAY(h9) = 10
Delete / Disable Quick Access
How do I delete entries or disable entirely this "Quick access" view in Excel/Word when clicking File -> Open: Recently migrated a user to Windows 11, now when they open Excel/Word, it hangs and then crashes while trying to enumerate this Quick access list. We're running Office 365 / Click-to-run Excel version 18730.20220.
Power-Query Manually Replacing Missing Data within Queried Column
Hello! I want to start off by saying I've never worked with Excel professionally before, I've only used it for very specific purposes that fit my Interest. So this might have a easy solution or plainly be impossible. My current interest is Tracking the meta-data of Articles I read online. Through Power-Query I've found a way to automate this to a point where I can just add the link of the article to a list of URLs and power-query fills out all the meta data, because I've trained it to pull the correct data through the "Table from Examples" function of Power-Query. Following the instructions of the following Article, I've Changed the code of the Power-Query to accept multiple links instead of one singular one with all the Data.: https://www.howtoexcel.org/how-to-extract-data-from-multiple-webpages/ The code looks something like this: let MetaData=(URL) => let Quelle = Web.BrowserContents(URL), #"Aus HTML-Code extrahierte Tabelle" = Html.Table(Quelle, {{"Title", "H4:nth-last-child(4) > :nth-child(1)"}, {"Author", ".heading:nth-child(1) A + *"}, {"Topic", ".landmark + .tag"}, {"Published", ".Date*"}, {"Publisher", ".category-slash *"}, {"DateAccessed", ".time*"}}, [RowSelector=".blurb"]), #"Geänderter Typ" = Table.TransformColumnTypes(#"Aus HTML-Code extrahierte Tabelle",{{"Title", type text}, {"Author", type text}, {"Topic", type text}, {"Published", type text}, {"Publisher", type text}, {"DateAcessed", type date}}) in #"Geänderter Typ1" in MetaData (It's in German, but Quelle=Source, "Geänderter Typ"="changed Type". I've modified it slightly to hopefully reflect the simulated Data later in this post.) This Connection is then used to insert a Custom Column and expand it, so the Data appears in the new table. The Problem I'm now having is that some of the Articles are only accessible with an Account on the page I'm using to read the Articles. This means that Power-Query Returns null for those articles across all columns. Original Table: Extracted Data: (This is manually simulated Data, not actual links to the articles) What I now want to do, is manually insert the Data for the Article in Row 4. I've coloured them red in this screenshot to show what I mean. However, if I refresh the table (For example because I've added more links to the original Table, because I've read more Articles), the red data disappears. My browsing of Excel Forums has taught me that it's possible to create a self-referencing-query to manually add data to a table, if that data is in it's own, new Column. However, since my manual data is in the same columns that the power-query fills out, and I lack the fundamental understanding how Power-Query or the programming language of it works, I don't see how this solution can help my case. I'd love to be proven wrong. I hope somebody can help. Thank you in Advance :) - YorinI need help create a pdf with a button
Private Sub CREATE_GARY_TEAMS_PDF_Click() Dim FilePath As String ' Specify the output file path FilePath = ThisWorkbook.Path & "\GARY NFL TEAMS SCHEDULE.pdf" ' Select the sheets you want to export as ONE PDF Dim SheetArray As Variant SheetArray = Array("STEELERS FOR FRIENDS", "CHARGERS FOR FRIENDS", "RAIDERS FOR FRIENDS", "COWBOYS FOR FRIENDS", COWBOYS FOR FRIENDS" , COWBOYS FOR FRIENDS""EAGLES FOR FRIENDS", "BEARS FOR FRIENDS", "49ERS FOR FRIENDS", "49ERS FOR FRIENDS", "CARDINALS FOR FRIENDS", "RAMS FOR FRIENDS") ' Ensure sheets exist before proceeding Dim ws As Worksheet, i As Integer For i = LBound(SheetArray) To UBound(SheetArray) On Error Resume Next Set ws = ThisWorkbook.Sheets(SheetArray(i)) If ws Is Nothing Then MsgBox "Sheet '" & SheetArray(i) & "' not found!", vbExclamation, "Error" Exit Sub End If On Error GoTo 0 Next i ' Export sheets as a single PDF ThisWorkbook.Sheets(SheetArray).Select ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=FilePath, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=True ' Deselect sheets to prevent selection issues ThisWorkbook.Sheets(1).Select ' Adjust to a default sheet MsgBox "PDF saved at: " & FilePath, vbInformation, "Export Complete""" End Sub Steelers Chargers Raiders Cowboys x3 Eagles Bears 49ers X2 Cardinals Rams I have a worksheet called Button on that is enabled. I need help adding 2 more Cowboys. button. I tried putting a button worksheet in a PDF. file, I do not want that Thanks You
Conditional formatting for row based on one cells value compared to 2 other cells
I’ve attached two pictures of a sales report. The black and white is what I’m starting with and the colored version is the goal (currently coloring it manually) I need the row to highlight a certain color if the data in column i of that row is less than the cell next to it (column J), or a different color if it’s greater than or equal to another cell (column k). Is this possible to do without having a different rule for each row? If so, how?The Dreaded "Duration" bug
Hi! I have today created an Excel file (from CSV) using data from our core system which deals with login/logout dates and times, and then durations based on the system usage in between. I have done the necessary splitting of date/time fields into date fields and time fields; and all the source data is formatted as "Text" so appears like floating point numbers. When I pivot the data, it retains the text format. I then select the body of the pivot table, and set the format to {CUSTOM} [hh]:mm:ss which SHOULD be a bare "duration" style format. It displays as that in the pivot table - but if I select on some of the cells, in the formula bar it displays DD/MM/YYYY HH:MM:SS format. On others, it retains the duration without a date. It's infuriating. When I check "Format Cells" no date codes are present; and yet here they are in the formula bar. This means that when I try to USE the data, it is garbage - I get no useful results. I'm stuck. I can't proceed. How do I fix this? Is it an Excel bug?
