Pinned Posts
Forum Widgets
Latest Discussions
How to retrieve the latest unit cost
Hello, I am sharing a condensed version of a pricing file that lists from Cols A to C Item Codes and pricing by date. The goal is to retrieve the latest unit cost for a particular Item Code. Here is the link: https://docs.google.com/spreadsheets/d/1wm9Ry7PGqM0qirY6GeKu1F9ZHzR3kFrj/edit?usp=drive_link&ouid=103354753371375324640&rtpof=true&sd=true Note: the formula in Cells F5:G48 may return N/A because of the link that automatically opens up as Google Sheets. In Cells F5:G48, I have attempted to retrieve the latest Unit Cost by first bringing in Unique Item Code from the repetitive Item Code in Column B. Unfortunately, the unit cost coming in for most of the items is incorrect. For example, Item Code: ABR00054 should have a latest unit cost from 12/6/2023 of $42.98. However, the xlookup(maxifs) function that I am using is bringing in $4.53. I thought that the formula shown in Cells G5:G48 would work but something is scrambling the formula logic. Can you please point out if the formula is incompatible with the source data layout as presented in Cols A to C? Please consider highlighting another formula that will be able to provide me with the data that I am looking for. Thank you. Regards, Shams.
How to refresh excel data and remove previous data automatically
I have to update a reporting template based on an excel sheet. How could I update excel sheets automatically and remove previous data? I can upend data by using Power Query refresh. I do not want that. I want only this week's data. Last week's data should be clear.
Excel: Count cells with specific value + colour
Hi there, I would like to be able to count the number of cells that contain a specific value and are shaded a specific colour. This is for a rota spreadsheet that will be tallying the total number of shifts which have been agreed. The cells that contain "Yes" as a value from a drop down list and are shaded green, should be counted as part of the quarterly total. I'm assuming that a VBA custom function would be needed for this. I've tried a few but cannot figure out a way to get this to work with both a specific value and colour. I would be very grateful for anyone that is able crack this challenge. In the example screenshots, it is the cells shaded in green that would need to be counted and the totals appear in column GJ. Best regards, DanielExcel for Mac Character entry into cell delayed til after all return entries processed.
MBA M2 Sequoia 15.6.1 (24G90) Excel Version 16.102 This issue started after recent update. When there is a big resource demand entries into cells used to be delayed, but would run correctly when resources were available. For example: Select cell A1 Type "A" Return Type "B" Return Type "C" Return This would produce A, B, and then C in three separate cells down the column, even when resource demand was high, the entries would just be delayed but entered correctly. Now, the process when delayed by resource demand, stores all the cell entries, first runs all return commands and then puts all entries into the last cell.Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel TeamFormule avec condition
bonjour J'ai un classeur de 13 feuilles, 1 avec les décomptes de mais différents repos, mes jours d'absences, mes nuits etc et 12 avec mon planning de chaque mois( noté de janvier à décembre), mon total de RU de départ est de 8(case B15 sur ma feuille décompte) et lorsque je faits plus de 5 nuits dans le mois( j'ai le décompte qui se fait sur chaque mois en case C12), je gagne 0,8 RU et je souhaiterai faire le rajout de 0,8 à chaque fois que la C12 de chaque mois est > 5 , en gros 8+0,8(si Janvier!C12>5)+0,8(si Février!C12>5)+0,8(si Mars!C12>5) .....+0,8(si Décembre!C12>5) Merci de votre aide
Reference sheet numbers in hyperlink
I want to be able to link a specific shape to a sheet by the sheet number, not its name. Using the standard method, by selecting 'hyperlink', only a list of sheet names appear. Inserting a onclick() macro into the initial sheet would work but I cannot figure out how to reference a sheet by its number. All help appreciated.
