Spreadsheets

6K

Solutions

22

Articles & Videos

4K

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

Hello,

I'm sorry for asking the solution again as the last one did not work as required, but I thank Shams for helping me understand the way it is done. :)

But the problem stays as it is.

So…

49 views
Free Tool: ZipGrep
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

I am looking for a formula to put the "status" of a project from the worksheet Matrix (2) in the right row of the reference table (1). I tried index match but could not solve the problem.

In the ws…

613 views

I have this formula in Q13:

=IF(OR($Q19="2: 1/4";"2: halv");0.225*1*0.25;0.225*1*0.5)

Then in Q19 I have a drop-down list with these values:

   -  
2: 1/4
2: halv

Note that the first …

1516 views

I'm trying to sum the number of dates with in a range for a given document type using SUMPRODUCT in the attached example spreadsheet.

I can get the formula to return the correct value for a single …

617 views

Hi Experts,

I have a somewhat complicated issue that I think might be resolved with the use of a combination of an Index Match Array formula but can't see how to do it.  That said, there may be …

534 views

I have a list of phone service providers with their area code beginnings such as ( 307-650      : Provide: SPRINT SPECTRUM)  and  I want to find whether which one (who) is the phone carrier using 10 digit …

1416 views

attached is the file with example data , column A is what i have and column B C D is what i need to get with formula.

any help is appreciated.

316 views

Please healp how transpose in yellow range values with formula. With transpose or with other formula...

512 views

have an list of numbers
but i need identifu the doublesas i type in

like the example  here

1417 views

I am trying to  move column A’s unique values from raw sheet to temp sheet this is the code I am using however it is taking a lot of tie to process when the entries are more than 50000 is there any …

519 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 have data in cel B7  IF IS TRUE I NEED POPULATE THE ADJACENTS  CELL  WITH A LIST OF VALUE

LIKE THE EXAMPLE HERE

HOW CAN I DO THAT ?

THNKS IN ADVANCED

4523 views

Dear sir,  i have matrix table in excel where its shows correlation between two stocks, i need to pick stocks if it has above 90% and between 80-90 % and so on .

625 views

i need a database that i can build to hold all on my marketing campaigns information

i currently have a variety of excel spreadsheets that i will import into the database as well

which database…

340 views

Hello,

Hoping someone can assist in developing a macro that will clean up a spreadsheet.  Please see attached where the 'Before' tab shows how the data appears raw and the 'After' tab shows how I …

333 views

I want to get a date like 23-Nov-2008 and get it to show the persons age this year - so not the age they are now if their birthday was in June but what they turn this year.

1732 views

Hi everyone,

I have a column in an EXCEL spreadsheet made up of a date and time in the following format - m/d/time HH:MM.  For example, 1/1/2017 18:24.  I'd like to separate this into two cells.  …

441 views

I have a basic spread sheet.  I have attached a sample.

I would like to sum column c if column b has the word "Swings" in it AND the date in column a is between 1-1-2017 and 1-31-2017

I cant …

328 views

Hi Experts,

I have a spreadsheet that contains dates in Column G.  If that date in Column G is greater than 7 or = to the present date, then in Column H when clicked, you are prompted with a "Yes" …

2055 views

I have a spreadsheet that has a model type in column A and could be any number of serial numbers in column B for that model. I need those broken up in separate rows and the model copied down as well …

1635 views
Free Tool: SSL Checker
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Hi,

I would like to find a closest match by comparing two columns in Excel. I tried VLOOKUP and MATCH but they return only if it is an exact match. Is there a way to find a closest match? I am …

767 views

In the attached spreadsheet, I have 2 tabs. The first tab is what I cut and paste my inventory into. In Column "M", I want to return from a list in the second tab the value for MIN, or the minimum …

1153 views

Hello - one of my users came to me with this issue.  Their spreadsheet starts spacing the rows and changing the highlighting colors after row 85, and they don't know why.  I can't see why either and …

436 views

I have a customer with 20 computers (Windows 10) connected to a SBS 2011 Server. They all run Office 2013 and they all have random issues with Excel locking up when they have multiple spreadsheets …

1258 views

HI
Is there a way to sort a block of data automatically from one part
of the sheet to another.
I have attached a spreadsheet which was sorted manually
To be sorted on column C
Thanks
Ian

858 views

im very simply trying to sum up 4 numbers in a spreadsheet.  and no matter how i do it.  excel does not add them up correctly.

if you look at the picture im trying to have excel sum up …

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

Spreadsheets

6K

Solutions

22

Articles & Videos

4K

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