## getting the latest date

have two sheets > SALES! & stocks! date & code in SALES!$C$6:$C$5088 & SALES!$E$6:$E$5088 respectively date out & item code in …

## Question****

Dear Sir/Madam, Data, 23,45,87,31,2,3,65,50,3,45,85 Question: How to formulate the above data from left to right when the addition is more than …

## lookup and reference

Find all the values in array1 that correspond to a number in Array2, i.e., for # “8”, the return would be “Al”, “Bt”. For # …

## Excel Formula

Hi, I would like to know what formula we can use to get the forcast of the PRE QA numbers from the disqualification trend we are having? for example: if …

## Iterations only done for some cells, even though the other cells have identical formulas

I’m doing a spread sheet which involves circular references. The iterations function has been enabled to allow the circular references to work. Basically …

## Complex Formula

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

## Как избавиться от боли в суставах?

Пантогор – гель для суставов быстро избавит от боли в суставах без вреда для …

## Conditional Formatting

Hello Im using dates on my spreadsheet and I want to show a date to be highlighted if its greater than another cell by 18 months, If its less than another cell …

## 500 min formula

I hope I can explain this correctly. I am trying to convert numbers that are less than 500 in a cell column to 500. But if a number in said cell column …

## Auto update slicer

I have a column of data organized by month. On a separate sheet, I have a pivot table and a slicer connected to this data. When I enter new data, I want the …

## Zoo porn reviews site?

Good morning, Weird web pages I’ve found on the internet – they have a lot of man on horse fuck webm zoo porn on this zoo review sites. It called …

## Data analisis help

Hi , I have the folowing information. Customers names, visit history, and how much they spent. I need to create a visual chart or graph that can be …

## Compare two values in an array and if they match in a row, return a value from the third column in the same row.

I am hoping someone can help me solve this specific problem. I understand it may have something to do with VLOOKUP, or MATCH and INDEX and array formulas but I …

## Excel formula

Im using windows 10 and excel2010 I am trying to come up with a formula that finds the highest ascending number in a sequence, the numbers are across columns …

## Excel Conditional Formatting

Hi, I’m currently trying to format cells in different columns so that when I select a duration option in one column, the rows in a different column are …

## repeating data based on other data

i’m still relatively new to excel. i’ve been working 15+ hours on this sheet and figured there must be a faster way to do this. essentially, …

## Excel vba IF THEN ELSE statement

Hi. I have two Subs: one inserts a shape (“Checkmark”) on top of another shape, a square, and …

## Auto populating data

If I have employee name (column a), employee number (column b)and a classification of employee (column 3). Master list on employees in sheet 2 I …

## Consolidating text data by reference number

Hi, I have a spreadsheet with 35000 lines. Each line contains a customer name and the archive box code where their information is stored. I need to …

## Sort data and form graphs

Hi there! Relatively new to excel, so please bear with me So I have a spreadsheet of data that sort of goes like this (NAME, AGE, SCORE, TIME) JOHN, 12, …

## How to extract a number from a text string in google sheet

HI In my google sheet A1 cell, this is written. <!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>Get …

## Sum certain cells

I have a column of 6 cells and I only want the top 4 summed up in another cell, how can this be done? By:

## If Statements

SEVRENE® 3000-70A-8870 XDV DARK SLATE Is there an If statement that would pick out SEVERENE from the above, change SEVERENE to SEV in another column, and …

## Returning project status based on dates in multiple cells using a nested IF function

Hi, I am trying to create a cell that shows whether a project is on track, late or ahead of schedule using multiple dates derived from multiple tasks within …

## Password

I need to reset my password for the protected sheets. I cannot get into the unprotected sheets on some with the password that was created. How do I rest the …

## Break or hide part of the text in a cell in Excel

Hello,I want part of the text below 1398/12/30 in a cell with a format or code or any other tool … I would say exactly 30 so that the text of 1398/12/30 …

## Mr

A learner has seven subjects, which include Home Language. Criteria to Pass: 40% in Home Language is compulsory, then at least 40% in any two other subjects …

## Formula Help

I’m creating a spreadsheet to help keep logs of jobs I do daily and weekly. I need a formula to add rows in a column, then subtract a certain amount as …

## EXCEL FORMULA

i Have creat a list of comapany name list there address and GST Numbers, Do a data validation its works but it can happed that the i m select comapny list bye …

## Formula needed

Hi, I am trying to establish a formula to reference certain cells between two tables as the below. Sheet1 Sheet2 In Sheet1 Return …

## Excel Learner

Hello. I would like to use a conditional formula for dates, years and months while color assigning it based on what ifs. It is not working. For example …

## Graphing

HI, I was just trying to figure out how to fix my x axis on a scatter graph. The first value doesnt start until 50 so there is a large empty space from …

## Sampling

Hi, In this sheet, I have an example with 3 columns namely Invoice no, LOB and name of the person. Now to start off with a sampling. I would need as output is: …

## Help with sum formula

I want excel to pick the two largest of three numbers where the cells are not adjacent. Example; total two largest numbers out of D4, G4, J4. Thank you for …

## VBA GetSaveAsFilename not saving as .csv

Hi All, Doing something wrong here. On button click I am able to open the Save As window/box, enter a name, but it won’t actually save the …

## Formula help

so I have 36 stores numbered 1-36 in a column, right next to that is another column that shows a grade given to each store. I would like to pull all the stores …

## Formula help

I have a spreadsheet that contains thousands of addresses under these coulumn headings : address number Pre-directional Street Name Suffix I have pasted …

## Engineer

Hi I am looking for formula to find a thickness higher than 0.295(calulated thickness) in column standard thickness available against the Size 3/4. Thanks In …

## converting trade number to words

I have to convert around 40,000 numerical codes into text and I would really like for a formula to help me out. These are labor codes for example, labor code …