Pinned Posts
Forum Widgets
Latest Discussions
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.
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
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?
Excel Paste as Image Issue
Hello, apologies if this is not the best place to post this. Whenever I special paste, as a picture, it shows my selected excel cells as a tiny top left section of the whole pasted object. I then have to crop the “image” to only show the actual section of excel cells and remove the clear components. Any assistance with this would be greatly appreciated as I havent had much luck finding this same problem online. I experience it whenever I paste from excel to powerpoint, excel to excel, or excel to powerpoint, but only as an image. Please let me know if this is not allowed on here!
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.
