Pinned Posts
Forum Widgets
Latest Discussions
Formula help multiple value lookup
I have the data below. I want to create a sort of calculator where the user will choose a manufacturer, panel amount, and method of payment and it will return the price. For example, they choose Trina, 22 panels, and cash and they get a result of $3.10. Can anyone help me figure out how to do that?
Finding Possible Matches to a Solution
Hello Everyone, I'm wondering if anyone has any tricks or formulas that I can use to find any possible combination of numbers that will create the desired solutions I'm looking for. Take a look at the picture I uploaded for reference. If I have a list of data in column A, I will be looking for a given set of numbers that will create a sum that matches column C. I'm looking for a trick or formula that will return all possible combination of numbers that will sum up to equal Column C and then return those possible combinations in another column for me to see (for example like what you see in columns E, F, & G). Does anyone have any ideas on how or if this can be done? I would like to do this without the use of complicated macros or other codes if possible.
Movement in spreadsheet as form after enter
When using an Excel spreadsheet as a form, is there a way to move from one cell location directly to another cell location after pressing enter in the first cell? What I want to do is have the user enter the width in cell B7, hit enter, and have B9 become the "active" cell, then enter the length in B9, hit enter, and have B11 become the "active" cell, so on and so forth. Essentially I want to skip from one input cell to another without having to go through all of the rows. Not all "moves" from one cell to another would be exactly two rows down, other locations in the spreadsheet would require moves of 3 or 4 rows to get to the next "active" cell. All of my moves would be in the same column though. Thanks to all who look at this.
Doing a search and replace on all embedded hyperlinks in a spreadsheet
We are in the process of migrating departments from file shares, to Sharepoint Online, and within many of the spreadsheets there are embedded links directly to files whose paths are changing. We are trying to do a search and replace to get rid of "file://fs-prd/etc/etc/etc" and replace it with "https://mycompany.sharepoint.com/etc/etc". We think this should work, but for the life of us we can't get it to. The problem is that all of these links are embedded behind other text, such as "click here". We can do a search and replace on "click here", but not on the actual link behind it. On the Find or Replace window, we've tried selecting all of the options in the "look in" drop down, but none of them work. We've been trying different ways of putting in the link we are looking for, such as "='file://" or just "file://", etc, but we haven't found anything that will bring us back any actual link. If you know how to do this, please let me know. Or if you know of a way to get rid of the "click here" and show the hyperlinks we'd be happy with that as well. Thanks in advance for any help!
Macro to copy
Hello all you "Brilliant Minds" here is a chance to prove your "Excel-ence. I want to copy a value to one cell from the source which is random and as I haven't a clue about this stuff I asked Microsoft CoPilot. Being on the 4th version Where Microsoft excel still will not accept Microsoft CoPilot's creation, I am appealing to the Community. So here is your chance to prove that you are smarter than CoPilot. Here we go, everything but attach a file. If anyone is interested send me an email so I can send a couple of small files. Donald
Countif/Countifs
I'm trying to do a standard countifs formula for several columns of information. Each column is using the same criteria but has different ranges. I'm trying to make an equation that will be easy to drag so I do not have to rewrite the range each time. Does anyone know how to do this? I have cells with the prewritten ranges I'll want to use. I can give more information if that helps people understand.
Custom Sparkline Formula
I am in the process of moving to Excel from Google sheets. I am trying to build a project sheet and add a formula that will provide a "sparkline" for quick reference of the projected start and end dates, and then based on the status of the task (not started, in progress or complete) and today's date in relation to the start and end dates of the task, change color (Green, yellow, red, etc). Here is the formula I use in Google Sheets, but I cannot get it to work in Excel. =SPARKLINE(if(OR(today()<D5,today()>E5),{int(D5)-int($D$2),if(D5=E5,1,int(E5)-int(D5))},{int(D5)-int($D$2),today()-int(D5),1,int(E5)-today()}),{"charttype","bar";"color1","white";"color2",if(G5="Complete","grey",if(today()>E5,"red",if(AND(today()>D5,today()<E5,G5="Not Started Yet"),"darkred",if(AND(today()>D5,today()<E5),"orange",if(G5="In Progress","orange",)))));"max",int($E$2)-int($D$2)}) In this formula, Column D represents the start date and Column E represents the specific task end date. D2 and E2 represent the Project start and end date. Any Advice?
