Spreadsheets

5K

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.

Refine results

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 …

312 views
Courses: Start Training Online With Pros, Today
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

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

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

1621 views

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 …

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

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

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

1239 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

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

1029 views

I want to create formula to check that in each row if the data is all the same in each cell then it should say "all Ok" if not then should say need attention. I want to check cell from column D …

1349 views
Gigs: Get Your Project Delivered by an Expert
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Dear Experts,

This formula might look strange and basically surely does not work:

=COUNTBLANK(Y5:Y&COUNTIF($Y4:$Y20000,"*"))

its target would be to place a formula which determines the range …

223 views

Hello Experts -

    I have a macro that I'd like to run.  All this macro does is simply highlight the row and column you are on for easy viewing.  After I save the code and go back to the …

232 views

I am using MS Excel 2016 and want to set things up so that conditional formatting is applied to "cell A" following a change in "cell B". So far so good, but there should be a time delay (e.g. 1 week) …

742 views

Dear Experts

I have been asked to create a spreadsheet which contains a list of costumers and their orders.
The customer can choose from a number of different fruits, such as apple, pear etc.
I …

322 views

So I have a spreadsheet that uses a lot of lookups/Index-Match type stuff.  I have been experimenting with different macros to process my data and have had success in doing so.  Problem is that it …

1155 views

Hello Experts,

I have created a Power Pivot Chart and added a Chart Title label to the chart.

I then ensure the Chart Title box is selected, I go to the formula bar and type in the location of …

2168 views
Office

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Microfoft. But sometimes people faces  problems  .

287 views

Hello,

I need help to build a macro that will allow  to cut a value from the selected active cell in active worksheet (ie "sheet1") to another worksheet (ie. "sheet2") but paste in specific cell? …

2744 views

I have a list a IP address' that correspond to specific locations. As IP address' go however, there are variations in the last digits. For instance, the Albuquerque office has IP address 183.18.2.15 …

3285 views
Live: Real-Time Solutions, Start Here
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Hello,
I have been provided an excel sheet from my management.It has 2 sheets.The first has all the raw data and the second has the summarized view of the first with all the formula.
Iam trying to …

1244 views

Dear Experts,

Can you please have a look on the attached file, I need to compare Payment terms which values 4 characters long ones as blue marked on the attached picture:



As you can see …

1453 views
Security

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.

0132 views

I got helped my Martin Liss for this post : Merging-Splitting-Multiple-Rows (https://www.experts-exchange.com/questions/28993659/Merging-Splitting-Multiple-Rows.html)

Now I would like to apply this…

2350 views

Hi all,

I've written a simple script that grabs the contents of the active cell and assigns it to a var here:

var valueactivecell = activecell.getValue();

I'd also like to grab the contents …

224 views

Hi all,

I have a simple Google Sheet script that basically copies the contents of the active cell, then pastes to a specific address in a different sheet. Part of the script goes like this:

  …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS Excel
    (129,418)
  2. MS Office
    (57,233)
  3. VB Script
    (36,397)
  4. Visual Basic Classic
    (163,614)
  5. Office / Productivity
    (5,015)
  6. MS Applications
    (43,173)
  7. Programming
    (52,029)
  8. VBA
    (5,763)
  9. MS Access
    (216,143)
  10. Analytics
    (406)