## Compare everything against everything

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 …

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 …

I don’t have much excel experience.i will appreciate if some one can help me with this code. I have column of dates and related data in two columns and dates …

I don’t have much excel experience.i will appreciate if some one can help me with this code. I have column of dates and related data in two columns and dates …

Hi! I have a report that I need to show the date the bill was paid on the same line. (QB wont spit out the report like this of course!) Currently, the …

I need help with some formulas on my excel dashboard but i am stuck how can i show you that data so that you help me. By: Anthony

Hi All, I’d appreciate your help on the below: Outline: – 3 people (Amy, Harry, Sophie) …

I wish to sum the following data. Each “E” cell refers to a weeks income. …

I hope the title makes sense, I don’t know enough about Excel to even be sure I’m phrasing it right. I’ve had difficulty searching because …

I have an external data source which I connected to using Excel. I used MS Query to make several pivot tables. However each pivot table is a connection. Can I …

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.