## 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 …

Microsoft Excel Formulas in Excel

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 …

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 …

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”) …

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 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 …

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, …

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 …

How can you combine an iferror formula with an roundup formula (but I need to round up 2 places)? Is there a way you can combine them? Can you show me on my …

I am struggling with an if and statement. I have 3 possible outcomes (B1000, B2000, B3000) based on certain critera. Want answer in column A, based on …

Hi, I am putting togethere a time sheet and i want to include exception codes. Specifically staff can only work between 07:00 and 19:00 and they can …

So I have a data set of lets say (for confidential purposes) doctor offices, the set looks like this; A B C D 1 Office Info 1 info 2 District Manager (DM) 2 …

i have pictures of Animals in Column B, and their Names in Column C. now i want to Show the Picture in Cell G1 when i Type Name from (Column C) in …

I have 1 question I used formula in Cell A1 in sheet 1 is =sheet2!B1 But when copy this formula to Cell A15 in sheet1 , it should return to =Sheet2!B2 not …

Hi, I am faced with a problem, where I have a data set in a sheet where for each date there are three columns – Manager, Time Scheduled & Time …

I am trying to develop a formula that analyzes a specific material that has multiple inputs on a datapoint (MS). There needs to be only one identified and it …

How do I extract the date if the given data are: 1) Week ending date 2) Days of the week (for which the exact date falls into) See example below: …

I have a list of all jobs worked by employees yesterday, my boss wants me to make an easy way to track the start and end times of the employees. It is a CSV …

So we are exporting data from FileMaker Pro. We have a column labeled as location and it will say something along the lines of: Tank II Rack 3 Slot 23. (There …

Good morning, I am having an issue with expanding formulas. I think an example might be clearer. Normally when you pull down a sequence of numbers it just …

Please enter the excel formula if you need the cell to show “0” if 3 plus 4 equals and “1” 3 plus 4 is either greater than or less than …

need help in advace axcel & vba By:

Using Windows 64 Excel 2010 I have medication every day I am trying to set up a sheet that shows how many tablets that I need to take when I go away some times …

I am not sure if this is possible, but I’m trying to write a IFERROR INDEX MATCH MATCH formula with a consecutive answer. I have some multiple cells with …

Any explanation regarding below – really welcome. =COUNT(‘433Up’!$F:$F) &” wk YTD Summary” …

I have a list of kids with fields to the left with “X” in them if they raised different amounts of money. I want to know the formula to list …

I currently have one column with just the currency, and another column with the currency value. I would like to combine the two so that the result would be a …

Hello, We have some daily deliverables and few same work done by multiple employees.So how can we allocate same quantity of work to each Thanks …

I am trying to create a series of one of my criteria to copy across the rows of my spreadsheet. The criteria is a date range. I am currently …

I am using excel 2011 for mac. I need to convert mm to inches. I know the formula for converting one number in a cell that is in mm to a number in inches but I …

Hey, If i have a cell range for foreg: a1:a100 and b1:b100 and i want to know if a1+b1=7 for each row and get the countif value that total 26 cells return with …

I am wanting to create an automated General Ledger and Journal Entries. The way I am wanting to set this is up is having a list set up that a user can choose …

I am using Excel 2016. I added four new rows to the middle of a lookup table. These rows ARE included in the formula. …

I have a sample like this where I want to find nearest value to average city and weight are two separate columns city weight A 23 A 22 A 45 A 97 B 34 B 22 B 23 …

Hello, I am looking to find some basic guidance on using Excel to create a sheet where I will be able to input one of our clients credit field to …

I am trying to use a simple COUNT formula. for example =COUNTIF(AG13:BE13,”>60%”) However my information is in …

Hi, I have an issue. Lets say I have 4 numbers (10, 50, 100, 250) and I want excel to give me the best combination of those numbers that will get me as …

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.