User Profile
SnowMan55
Bronze Contributor
Joined Oct 08, 2022
User Widgets
Recent Discussions
Re: Formule voor zoeken tekst
I will try to attach a workbook that has more use cases. Edit: That failed, so here is the file on Google Drive: 2026-01-17 EDWI wildcard search for rows.xlsx Translation by Google Translate… Vertaling door Google Translate... Ik zal proberen een werkblad bij te voegen met meer voorbeelden. Bewerking: Dat is mislukt, dus hier is het bestand op Google Drive: 2026-01-17 EDWI wildcard search for rows.xlsxRe: Welcome to the Excel Community
Asking questions is what this forum is (mostly) about! Near the top of the main page... * You can use Microsoft OneDrive or Google Drive or Dropbox or ... BE SURE TO SET SECURITY such that everyone can read the file, but noone but yourself can edit (change) it. ... While files can be attached to a post (and to replies to a post), it seems that "newbies" such as yourself are not immediately permitted to do so. (And since the forum software was supposedly "improved" in November 2025, many members have found that the file they attach disappears.) So you would be taking a chance by assuming you could attach a file to your first few posts. Many people instead insert an image (a partial screenshot) in their post, though that is not as useful as a file. ** Include information about which Excel product (Excel 365, Excel 2019, etc.) you are working with, on which platform (Windows, Mac, the web, Android...). If you are not confident in the clarity of your question, describe what you are attempting to do, in general terms. If you find an old post (say, older than 6 months) that is relevant, include a hyperlink to it and explain why the responses to it do not resolve your issue (avoid the temptation to add a reply to it).Re: Complex equations with multiple input values
That's not a lot of information you are giving us. For starters, which Excel product (Excel 365, Excel 2019, etc.) are you using, on which platform (Windows, Mac, the web...)? Sometimes, the solution requires an Excel function or feature that is not present in older products. The Excel formulas will depend on a number of factors; see the Calculations worksheet in the attached* file for my guesses. Collecting those factors into one sheet, separate from the reference data, makes things clearer. And without further information, I will assume that a larger Illness Factor should result in a larger MER. (I multiply the RER by the Illness Factor to get the MER.) There should be no reason for the users to enter a shorthand notation for the food product; selection from a dropdown list of the product names (possibly including container sizes) should be made available. Excel's Data Validation feature allows this. If any of your offered diets involve multiple food products, some design changes would probably be needed. But this should give you a start, and help you develop ideas for the design. Read the _Info worksheet for more information and references to documentation/tutorials. * The "attached" file might not be attached. Following a change to this forum's software in November, files that we attach frequently disappear. If the attach does not work, I will put the file on OneDrive and post a link to it. Edit: retrying the attach Edit #2: That did not work, so get the workbook here: 2026-01-07 CT08 feeding calcns.xlsxRe: Worksheet tabs to include date from a cell
Assuming that your "linked to cell H1 on tab 1" means that H1 on the user-input worksheet is referenced in an Excel formula on another tab, yes, that can be handled, in one of at least two ways. I will try attaching a workbook (built from Lorenzo's starting work). The forum software may or may not accept it. Edit: That did not succeed, so here's the workbook on OneDrive: 2026-01-06 RB AutoRenameWorksheet.xlsmRe: Welcome to the Excel Community
Yes, that might be handled with a single formula on your Single worksheet. It might be handled like this (depending on your version of Excel, which you should mention when posting): =SORT( VSTACK( 'Company Type 1'!A2:.A999, 'Company Type 2'!A2:.A999, 'Company Type 3'!A2:.A999, 'Company Type 4'!A2:.A999 ) ) Naturally, you would use your worksheet names, and change the column letter from A to whichever column contains the company names (it can be different for each worksheet). And by using a "higher" letter right after the colons, you can retrieve multiple columns at once. VSTACK info The periods immediately after the colons reduce the ranges to however many rows contain data, as described here; just remove them if your Excel version does not support that. In the future, please do not add your question/issue/problem to the end of an unrelated post such as this. Instead, click the big blue "Start a Discussion" button near the top of the main page to start your own message thread.Re: Formula to retrieve data from several sheets and return values from given criteria.
I agree that your formula structure works if the formula is entered correctly. But do you actually need/have the staff member's name entered twice on the source worksheets (both columns C and D)? See the attached workbook for more information. Edit: The forum software is "losing" attachments frequently. Trying again... Edit: The attachment was "lost" again. Including a link to OneDrive instead: 2025-12-11 SWEX staff location by day.xlsxRe: Need help with conditional fomatting formula based in text on cells
While others have posted basic formulas, it occurs to me that they may result in "false positives". I immediately thought of the INC in LINCOLN (whether a given name such as Lincoln Chafee or a surname). Other people who would be incorrectly highlighted: Prince R. Nelson (yes, "the" Prince) Linda Prince (film producer and director in independent cinema) anyone with a surname of Finch I don't know if you are attempting to select all businesses (and even all organizations) in your data. These would be highlighted: Incarnate Word Church (not their exact title, but you get the idea) Incredible Weddings Agriculture & Clean Energy Incubator (Texas) Inca Design (UK) And other hypothetical businesses also (I made up these; no guarantee that they do not exist): Principal Realtors It's A Cinch (rope store) Cincinnati Grocery Provincial Apartments Carpet Cleaners of Distinction Invincible Law Office Ye Olde Incense Shoppe Fragrances, Charms & Incantations Springfield Incineration Facility The Income Builders (financial advisors) Inchworm Babysitters Incomparable Cleaners Incalculable Wealth Advisors "Inconceivable!" Assassins of Sicily (Wallace Shawn, Proprietor) And "LLC" has a similar, but smaller problem: Hillcrest Manor (Texas) Hellcat Firefighters Ecclesiastical Skullcaps of New York You can exclude many of those names (if desired) by adding a leading space before INC and LLC. (A period after INC would be good, but I don't know how "clean" your data is.)Re: Excel cell calculation
Excel evaluates mathematical expressions according to the PEMDAS rule, which you may have heard of: (first) evaluate what is inside Parentheses; next evaluate Exponentiation; next evaluate Multiplication and Division (left-to-right); next evaluate Addition and Subtraction (also left-to-right). But Excel has a few more operators, so see this Microsoft documentation, specifically, the Operator Precedence section.Re: Excel Formula Help!!
See the attached workbook (assuming the forum software attaches it; lately, it has increasingly failed) for my ideas. Oh, and in the future, please identify which version of Excel you are/will be using (Excel 365, Excel 2019, etc.) on which platform (Windows, Mac, etc.). Edit: Yes, the attach failed; trying again. Edit #2: That failed also. The third time's the charm? Edit #3: Nope. Here's the link to a shared copy on One Drive: 2025-11-14 PLUM budget with overspending.xlsxRe: Few cells in Date column is no formating
The problem is the data in the Date column of Table3—some of it is stored as text data, even though to the eye, it appears to be a date value. It would be best to "clean up" that Date column data, replacing those apparent dates with actual dates. Alternatively, for the most part, you could have your lookup formula convert the XLOOKUP return value, such as this: =DATEVALUE( XLOOKUP(D17,Table3[Consignment ID],Table3[Date]) ) But some of the data will then cause a conversion error. Note that "30-Sep-202" is missing the last digit of the year.Re: Adding Cell Value to file string
I gave three suggestions. Which did you try? In other words, show your formula (exactly). And which version of Excel are you using? (The CONCAT function has been available since Excel 2016, the TEXTJOIN function since Excel 2019. If you are using one of those functions with an older version of Excel, that would explain the #NAME? error.)Re: Looking up specific period financials from multiple period worksheet
This forum makes it difficult to see the images that are included in a reply. (It works OK for images in the initial post.) So I will ignore the conversation you have started with Peter. See the attached workbook for two other possibilities. Edit: The forum software again fails to retain the attached file. So...
