User Profile
ExcelExciting
MVP
Joined Jun 15, 2018
User Widgets
Recent Discussions
Re: Formula 4 week rotation excluding Fridays and weekends
I hope below solution will resolve you issue for 4 weeks rotation... Week Number Formula =INT((DAY(B1)-1)/7)+1 Weekday Number (Mon=1) =WEEKDAY(B1,2) Employee A WFH =IF(AND(B3<6,CHOOSE(B2,1,2,3,4,1)=B3),"W","") Employee B WFH =IF(AND(B3<6,CHOOSE(B2,2,3,4,1,2)=B3),"W","") If this resolves your query don't forget Mark as Solution.Re: Website Power query connection
What I can see power query do suggest you a table name Tabular Data, may I know what version of excel are you using. however below is the M code let Source = Web.BrowserContents("https://www.bsp-southpool.com/day-ahead-trading-results-si.html"), #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE:nth-child(2) > * > TR > :nth-child(1)"}, {"Column2", "TABLE:nth-child(2) > * > TR > :nth-child(2)"}, {"Column3", "TABLE:nth-child(2) > * > TR > :nth-child(3)"}}, [RowSelector="TABLE:nth-child(2) > * > TR"]), #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]) in #"Promoted Headers" If this resolves your query don't forget Mark as Solution.Re: Unable to take the htmlpage value for formula
When you are retrieving the value, it is returning as text due currency symbol "₹" Below formula shall be helpful for you. =VALUE(SUBSTITUTE(INDEX(IMPORTHTML("https://www.goodreturns.in/gold-rates/bangalore.html","table",1),2,2),"₹","")) If this resolves your query don't forget Mark as Solution.Re: deduct 5% formula question
Assuming that your cell B2 = Project Completion Percentage (eg. 48% or 0.48) cell C2 = otal Amount Requested for Payment than your an use this formula =IF(B2>=0.5, C2*0.1, C2*0.05) this will checks if the project is 50% or more complete if yes then retainage C2 * 10% else C2 * 5% If this resolves your query don't forget Mark as Solution.Re: Missing image when Save as Adobe PDF
This issue might happens because Adobe Acrobat is not correctly integrated with Excel, causing the conversion to rely on the default printer driver instead of the Adobe PDF driver. try uninstalling the Adobe PDF and reinstall it again. Hope this should work for you. If this resolves your query don't forget Mark as Solution.Re: How to get a dropdown list of numbers, not dates?
When you paste the value in cells its automatic formatting changes it to numbers and we need to explicitly store it as text. There are two way to deal with this issue: Type an apostrophe (') at the beginning of each entry if you have limited values. '2025-04-01 10:00 '2025-04-01 10:30 this store the value as text Formula version which is more effective for larger dataset, add helper column and use the function TEXT() to convert these values into text and reference dropdown list to the helper column. =TEXT(A2,"yyyy-mm-dd hh:mm:ss") If this resolves your query don't forget Mark as Solution.Re: How to fill in the blank cells without scrolling in excel after applying filter.
Could you please share your dataset sample? If your goal is to fill only the blank cells with a specific formula, you can easily do this by selecting your data range, then pressing F5, clicking Special, and selecting Blanks. Once the blank cells are highlighted, press F2, type your formula, and then press Ctrl + Enter to apply it across all selected blank cells simultaneously.Re: Copy formula in Rows and Excel without changing the reference manually.
Hi max342ss Looking at the image I understand you are trying to reference a formula on PivotTable, Keep the cell on the Pivot Table PivotTable Analyze & Design Tab will be activated in the Excel Ribbon Select PivotTable Analyze > Option > Uncheck “Generate GetPivotData” this blog might be helpful for your query How to remove GETPIVOTDATA in Excel for Mac and Windows Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert If you find the above solution resolved your query don't forget to mark it as Official/Best Answer to help the other members find it more
