Spreadsheets

6K

Solutions

24

Articles & Videos

5K

Contributors

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Related Topics

  1. Microsoft Excel
  2. Microsoft Office
  3. VB Script
  4. Visual Basic Classic
  5. Office / Productivity
  6. Microsoft Applications
  7. Programming
  8. VBA
  9. Microsoft Access
  10. Analytics
Refine results

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…

1117 views
Free Tool: Subnet Calculator
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

please see attached file.

i tried modifuing formula from (CODE)

to (CODE)

did not work.

how can i make this work so that it starts from C2 not C1

113 views

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

432 views

Hello,

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 …

614 views

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 …

39 views

Hi, Does anyone have the code to loop through a folder and combine all the spreadsheets present into worksheets on a master spreadsheet?

513 views

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

820 views

Hello,

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 …

2421 views

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

415 views

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…

220 views
Free Tool: Path Explorer
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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 …

425 views

Hello,

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 …

526 views

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

1225 views

Hi

I need to change
FAB
GAB
HAB
IAB

to
FAC
GAC
HAC
IAC

how to do this using formula?

1238 views

i need count all the combination of an number
in an list of numbers

any help please

3131 views

Hi,
I'm having trouble copying rows down after editing an array.
Can you please alter the ranges in attached spreadsheet and copy down
thanks
Ian

2435 views

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 …

1433 views

Greetings!
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

Column P:
P2 asks: if H2 < 20 and G2…

223 views

Hello -

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 …

330 views
Free Tool: IP Lookup
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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"

326 views

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…

330 views

Hi,

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 …

549 views

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…

330 views

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 …

538 views

Hi
Could you please help to sort time order with one condition.
All explained in attached sheet
Many thanks
Ian

1045 views
Show more content
201506-LO-Top-001

Spreadsheets

6K

Solutions

24

Articles & Videos

5K

Contributors

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Related Topics

  1. Microsoft Excel
  2. Microsoft Office
  3. VB Script
  4. Visual Basic Classic
  5. Office / Productivity
  6. Microsoft Applications