Explore Spreadsheets on Experts Exchange

Expert Solutions for Your Tech Problems

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed...

Read more
  • 7.3K Content
  • 2.0K Contributors

Expert Spotlight
Developer & Coffee Roaster

I have over 30 years experience in Sales, Marketing, Technology and Developing solutions.

Troubleshooting Solution

Use keywords to indent nested structures in Excel

96
Attached is an example Excel spreadsheet with syntax similar to a table in a 60 page word doc. It …
Article

Excel - Did You Know !

10
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.
Video
Post

Oy... You ever make some changes to the underlying data …

7
Oy... You ever make some changes to the underlying data columns in a spreadsheet and then not …
Troubleshooting Solution

I need  a script to take 2 hours off a time in a google sheet cell.

57
Hi techs,
I need  a script to take 2 hours off a time in a google sheet cell.  Any assistance is …
Video
Troubleshooting Solution

Comparison of Values between two sheets

73
I initially had the code to do the following :
Compare the ranges between between sheet1 and sheet2…
Troubleshooting Solution

Convert col/row reference to heading/row reference

12

I wish to replace the col/row reference with heading/row reference. I have several worksheets using

Troubleshooting Solution

Show current time on separate rows for each time zone

43

The objective here is to be able to show the current time for each time zone by putting the time

Troubleshooting Solution

Trending calculation spreadsheet

62
I have space available numbers in a spreadsheet tracked over time. I also have space used numbers. I…
Advice Solution

Excel IF function - Multiple criteria

4

Trying to write formula in Excel. IF function with multiple criteria.


ex: if b7 = travel then

Troubleshooting Solution

how to calculate number of months that falls in 2003 between two dates

45
how to calculate number of months that falls in 2003 between two dates

lets say that my start …
Troubleshooting Solution

How should I solve the problem Microsoft Excel is waiting for another application to complete an OLE action?

56
I already followed the advice here, but even when this setting is ticked I can't open any of my …
Troubleshooting Solution

Convert pivot table text from SQL in Excel

48
Hi,
How can I format text to values from a pivot table ?
Here's the scenario.
I accessed an SQL …
Video
Troubleshooting Solution

Excel 2010 - sum total in column based on date

bymabehr
52
Attached I have a scrubbed version of a spreadsheet I use. What I need is the following when I click…
Troubleshooting Solution

Automating consolidated xls files to email

51
After individual consolidated files are produced, these are being emailed to the associated sales …
Troubleshooting Solution

populate  some cells after data verification

45
I have data in cel B7  IF IS TRUE I NEED POPULATE THE ADJACENTS  CELL  WITH A LIST OF VALUE

LIKE …
Post

Keyboard shortcuts in Google Sheets for inserting a new row:…

3
Keyboard shortcuts in Google Sheets for inserting a new row:

In Chrome on Windows or Linux:
Troubleshooting Solution

Sort two ranges without blank rows

43
Hi
I wanted to sort data without missing rows
I have enclosed a sheet with explanations.
Most …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more