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.1K Content
  • 2.0K Contributors

Expert Spotlight
Engineer

I am a civil engineer by profession and working in the field of water resources engineering as a structural engineer.

I have used Microso

Troubleshooting Solution

Reference formulas in other worksheet

20

Hi,

I would like a formula that would save me time by referencing formulas in Sheet1

and using them in

Article

Excel - Did You Know !

byShums
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
Tutorials
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

Count Specific values in an indexed range.

8

Hi

I would like to count number of specific values.

I have attached a sheet with explanation and

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 …
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 …
Troubleshooting Solution

Excel VBA to Import all worksheets in all spreadsheets a folder into 1 single spreadsheet

14

Dear Experts
 
In Excel, I am trying to create a macro to import all the worksheets in all the

Troubleshooting Solution

Need to manipulate Excel sheets may be through VLookup

bynQuote
14

Hello. I have three Excel spreadsheets - A1.xlsx, D1.xlsx and I1.xlsx. The three spreadsheets will

Video
Troubleshooting Solution

Generate individual txt files from spreadsheet rows

3

I would like to generate individual HTML / TXT files with values from a spreadsheet / CSV to be used

Troubleshooting Solution

Blanks returned instead of zeros

15
Hi,

Blanks returned instead of zeros as per formula.
Pls see attached NOT-RETURNING-ZERO.xlsx
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

Trying to replace first two digits in number Excel by using REPLACE.....but keeps erroring

byYashy
16
hi guys
I have a load of mobile numbers that have 44 in front of them and I want them to be removed …
Troubleshooting Solution

Was Excel Solver Add In created only for 32 Bit Excel

4
Hi,

I am about to install Office 64 bit (NOT 32/64 bit) and wondered if the add in Solver was created …
Troubleshooting Solution

Microsoft Excel Conditional calculation

15
We are using an excel spread sheet to track the ESN (electronic serial number) on RF id tags as they …
Troubleshooting Solution

IF  false do nothing

6
Hi,
I am wondering if there is a condition that leaves the cell as it is if a if command is not met.

Troubleshooting Solution

Excel  Formula - Highlight Row and Write to Column

bycredog
5
I have the following formulas to highlight rows when the condition is met.  I would also like to …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more