## If cell contains part of a differnt cell range then enter the number

Hi, Could anyone figure out a formula for this? If A2 contains all the text (not an exact match) from any cell from range B2 …

Hi, Could anyone figure out a formula for this? If A2 contains all the text (not an exact match) from any cell from range B2 …

Hi, I’m looking for a solution to a problem. I have an excel sheet that upon using a macro it adds a whole new row with a ” # ” in a …

Hi, I have the below formula in an excel file: =-$C$109*SUM(O105)*(O6=$I$5) I don’t understand what the second equal sign is suppose to …

how to i convert 00 hours 04 minutes 44 seconds into a regular time lik4 04:44 in excel? By:

hi. i need help to creat formula to count the cells of two columns containing specific text, but it should also eliminate duplicates. i have 2 colums with data …

Hi there! Currently working on something that adds hours up over 4 weeks to sum the total hours worked in a month. However, I cannot allow the spreadsheet to …

Hello, I am looking to find a way to divide certain value based on the drop down choices in excel. What I am trying to do is to make a way to …

Hi, I got this table right here in Sheet1: A B …

Using Excel 2016, how do I compare every row to every other row, and see which are most/least similar? Example: 4 rows with 6 numbers each in them. 2 4 …

I am trying to forcast a the size of an agent’s funnel of orders based on the following criteria: I know that: – Each agent will be assigned …

I have an Excel dashboard (no VBA) that connects to external platform and via some DLLs displays live data into the cells. Many people are using this dashboard …

I need to return a value from a specific cell, based on whether a date in another cell is 1 year, 2 years, 3 years, 4 years, or 5 years older than …

How to add a date match as an AND condition to sum, when the values are horizontal/rows and are not equal. They do not match in size criteria; which is …

I would like to link a chart from one Excel workbook to another. However, the chart formatting (chart titles, colour, chart type) is not included in the link. …

I am using Excel in Office 365 and cannot figure out how to get a total of how many unique numbers are in B20:B200 on four sheets (FY19Q1, FY19Q2, FY19Q3, …

Hi, looking for help. I have created a drop down list with a number of short patters. What I am now looking for is for a selected shift pattern to …

Hi, looking for help. I have created a drop down list with a number of short patters. What I am now looking for is for a selected shift pattern to …

Scenario: Column A is a list of products (30 lines) Each product is assigned a value in Column B (either “Exclude” or “Include”) …

Hi, I was wondering if you can please help me. I have an excel 2010 spreadsheet which derived from Active Directory (report). I need to find out how many user …

Hi there, I’m looking for some help as I’m not really sure of the correct terms to use on my query below, so whilst normally I would google …

In our computer system, we have different codes for everyday tasks. Problem is the codes are different for each division we have. For Example: …

Hi, I am trying to find ClickToRun folder in registry using VBA. If I search the folder manually, I am able to find it. But if I use VBA code, it cant locate …

I will do my best to explain what I’m looking for – I hope it makes sense! I have included a bit of my worksheet so you can hopefully understand …

I WANT TO KNOW ABOUT EXCEL FORMULA WHICH CAN GET 3 (THREE) EXACT VALUES MATCH OUTPUT FROM OUT OF 4 COLUMS. EXAMPLE – EXCEL SCREEN ATTACHED. …

hi i need to know if i want to enter a certain word in a cell and i need a value for that word in numerical digita in another cell, then what formula would i …

how to select certain cells in excel VBA CODE for ex: “B2:B16384,C3:C16384,D4:D16384,E5:E16384,F6:F16384 TO XFD16384:XFD16384” Like decrease cell …

Hi, I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in another …

I would nee help to find the right formula for my spread sheet By: romain

Hi, I would like to ask if is there any way to add values to a cell continuously? Example: I would like for E2 to have the values of E14 summed up. Like, …

As stated in the title my question is how to join the text of two adjacent cells. For exaple if cell A1 says “happy” in it and cell B1 says …

how to delete certian cells in excel By:

Hi All Im wondering if somebody can help I am using the below formula to calculate hours it all works apart from if a cell is empty for …

Hi, So im trying to build the timesheet below. I need the times worked. but i also need there to be one volunteer hour if the worked hour is 7 or more. …

Is it possible to move Excel columns? If I have done some inputting and decide that I’d like column H details in column B – is there a way of …

Let’s suppose we have User A .A refer B so A Earn 10rsNow A refer C so A earn 10rs Now B refer D and E so A earn (10+10=20)but B also earn (10+10=20) Now …

I am making a budgeting book that will work for my needs and budget to work with my business, So far, it is set up as follows; SHEET 1 – Record a …

i want to calulate avegare of three numbers if one number having some error then averge would be calculate of two numbers i want formula for the same. …

Hello, I have a worksheet that has the user ask how many stages they need on “Stage1” worksheet and then stage1 worksheet is copied. I have a …

=IF((U182+V182+W182*0=0),(T182),(U182+V182+W182)) What this formula mean By: Vikramaditya

thank you for this amazing website. i need some help with excel issue , it might be easy from some but i couldn’t get it to work with me. i work in a …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.