Spreadsheets

6K

Solutions

24

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

Hi,
I need help creating a VLookup function in Excel 2016 for Mac. I have struggled with this problem for years, and I am finally asking for help! ;-)
I need to find the ID for each analytical …

1024 views
Free Tool: Postgres Monitoring System
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Experts,

I have made a pivot of the attached but I cant seem to manipulate it the way I want.
The raw data is organized as DD Amount ("draw down amount"), DD Date, Repay Amount, Repay Date, …

620 views

Hi Experts,

I have recently switched from MS Excel 2013 to 2010 becasue of which formulas like NA, NUMBERVALUE are not working.



Any help how to get the above formulas working into Excel …

725 views

I had this question after viewing how can this formula be modified so that it doesn't require control shift enter …

937 views

I have column A in sheet1 and Column A in Sheet2

in sheet3 Column A i want to list unique list of all values that exists in Sheet1 ColA and Sheet2 ColA

please see attached.

935 views

I had this question after viewing multiple table in one worksheet into one master table using userform …

251 views

I have a Power Query from a table.  As I am still learning about what Power Query can do I am struggling with Grouping.

What I am trying to do is:

Group by Customer, by level 1, show the …

225 views

Hello,

I have a spreadsheet with the below layout:

group1            group2
computer 1    computer 5
computer 2    computer 6
computer 3    computer 4
computer 4    computer 1
.....       …

1430 views

Hello everyone,
I have a large spreadsheet which needs to be broken down into smaller pieces of data. Please see attached for a sample of the spreadsheet, with some fake data.

I need the …

342 views

Hey. Please check the this screenshot:



Each row is of a different product that we sell, with the corresponding data. I am trying to also include a picture of each of the products.

So far, I …

228 views
Free Tool: Site Down Detector
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

I have a formula, for example b1/d20. Now I want to copy that formula to the all the cells below it without changing d20. I want all of my results to divide by d20. I did the ctrl-down and d just keep…

530 views

I need a formula that extracts out the name in the url and displays it in each cell like you see in column D in the attached sample file.

Any ideas experts?

646 views

Hello,

I have a Excel spreadsheet which has the following layout:

Column A     Column B
name1          name3.mydomain.com
name2          name5.mydomain.com
name3          name1.mydomain.com…

145 views

I would like to have a calendar that will show days of the week by month and will allow the user to enter data for each date, and show totals.

331 views

Good day Experts -

I have an excel sheet which contains the below format (Lets call it "Data")

Column_A    Column_B    Column_C
AAA                123                 ABC1234
AAA              …

949 views

Hi Experts using excel 2010

I have the following formula in my workbook which works fine for all rows expect 6 row....where it returns #N/A

=INDEX(AC63:AH63,MATCH(REPT("C",255),AC63:AH63))

in…

935 views

I would like to format a cell based on a specific date - the cell has a formula in it.

Example: Cell R2 has a formula in it
I would like to have it turn 'red' if it is past '4/15/2017'

2232 views

I'm trying to get a formula that looks up the date in that column and compares it to a list of holidays. If there's a holiday I want it to report the holiday name.  If there isn't a holiday then I …

330 views

Hello,

Trying to find a way to convert a list of time  values in Zulu to local time.  Column B has a list of values 01Z, 02Z, 03Z, etc... down to row 20.  I need in Column C and D to convert the …

444 views
On Demand Webinar - Networking for the Cloud Era
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

column C (ActType) has the following items in it:  PRDIEM  PSNEOT  PSNE1  PSCROT  PSPR1  PSPR2

I need to fill column K (GL) with the appropriate GL acct #'s:  800100  800110  800200

Based on the…

424 views

Experts,

How could I modify Col G formula to return SAIBOR rate as shown on the "Set Libor Saibor" if the Facility is either SAR Procurement (R2) or SAR Wakala (R2) but if not either of those then …

1352 views

I'm using excel 2016

If I have a column like this:

EmployeeID
1
2

If a Select the cell for the number 2 and then I select Fill, then Series and then set Step value 1.
I chose Rows, Linear…

327 views

Hello Everyone,

I am spacing out on a way to do some work.  I have a need for looking at an employees work hours based on some information from an event log.  Currently I pull various event ID's …

227 views

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to do.

5304 views

I have three formulas that return a result when a dollar amount is input.
I would like to combine the three into ONE formula.
I will need three $ inputs but my formula would return only one comment.…

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

Spreadsheets

6K

Solutions

24

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