I am attempting to Search within a cell for certain values ie.("Fail - Do Not Load" &/or "Warnings" or not found within the text.
If the value = true than return "Failure" if criteria = Fail... or…
please see attached file.
i tried modifuing formula from (CODE)
did not work.
how can i make this work so that it starts from C2 not C1
Please help! I have excel files that include thousands of data points.
One file contains case number, date of birth, age, subunit, and price.
The other contains case number, date of birth, age, …
While trying to add additional rows to the formulas below (Example C9:C:400 or AC9:AC400) then hit enter and the formula pops up but it is not functional. I'm at a loss. ANY help would be …
I have 1 Numbers file and 1 .CVS file. Both files have same data types - First Name, Last Name, email address.
How do I merge these files to become one Numbers (version 4.1.1) file with all First …
Hi, Does anyone have the code to loop through a folder and combine all the spreadsheets present into worksheets on a master spreadsheet?
I have a column of numbers H4:H493
I would like to create a query in cell below H493 which does the following:
return a count of all cells containing a value range of 0-19
Next, I …
Please see attached Excel file. I'm trying to create a spreadsheet that calculates billable time correctly by separating time between 8 AM and 5:29 PM to be billed at $50/hr, and time …
I am trying to bring in a Post Code from one sheet (Sheet2 - imported from outside source) into another sheet (Sheet1).
The formula I am using appears to be correct EXCEPT for the …
Table 1, Column B has an index-match formula, whereby the results will either be no value or AU######
I need a formula for Column I using the following criteria:
If Column B is blank, then sum Col…
I am interested in obtaining a list of zip codes in some specific counties in California. Of course I can find them on-line, but I prefer NOT to have to manually copy them.
Is there any available …
Is there a way to VLOOKUP (or something else) off more than one field to bring back a results? The problem I have is, I have a file number and a date field. Then I have other report with …
I've got this formula set up
=SUMIFS(D:D,A:A,$N17)/GETPIVOTDATA("[Measures].[Distinct Count of WeekNo 2]",$N$16,"[Range].[Employee]","[Range].[Employee].&[Dave]")
How do I reference the [Dave] …
I need to change
how to do this using formula?
i need count all the combination of an number
in an list of numbers
any help please
I'm having trouble copying rows down after editing an array.
Can you please alter the ranges in attached spreadsheet and copy down
One user is constantly experiencing Excel crashes. Have even switched PCs for the user but problem persists. Excel Autosave also does not work as intended.
So I am wondering how to set up automatic …
I have two columns which I want to perform two similar operations against 2 other columns: one containing numbers 1-100 and the other a text entry
P2 asks: if H2 < 20 and G2…
I'm trying to generate a spreadsheet of random data for a presentation. In sheet1 column A I have a list of unique employee ID's ranging from 1 to 1000 (A2:A1001). In sheet2 column A I …
Greetings, I have 3 columns (b, c, d) with Year, Month, Day. I would like to merge the values of the 1st 3 cells/columns into the 4th column
eg. in this order for line 2 in column E: "C2/D2/B2"
I have designed a simple form to record specifice entries made by our end users.
The box to the right of "SERIAL # OF EQUIPMENT" will always have a different Serial # inserted when this spreadsheet…
I need a non-VBA solution for this in case I need to edit later. Basically, I need to sum one column based on criteria from another column. In the attached example, I need to sum column B …
I have an Excel workbook with two tabs, Lookups and data. I need to populate columns D, E, and F on the data tab from the data in the Lookups tab. I need to look at the code in column C (on the data…
I have two columns
1st column has dates
2nd column has numbers from 0 to 11
I have two fields on a Start Date and End Date where user can enter dates, I want to then search the data tab and …
Could you please help to sort time order with one condition.
All explained in attached sheet