Spreadsheets

5K

Solutions

25

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 want to create a spreadsheet that only has a few drop-down boxes or text fields where a person can select their name from the list, enter their data and have it automatically added to the sheet that…

1235 views
IT Security CISA, CISSP & CISM Certification

Master the advanced techniques required to protect network resources from external threats with the IT Cyber Security bundle. Built around industry best-practice guidelines, the IT Cyber Security bundle consists of three in-depth courses.

Hi,

I have an excel workbook with 50+ worksheets.
I need to consolidate all those 50+ sheets into another sheet on the same workbook.
Something like Sheet 2 copied data under sheet 1, then sheet…

334 views

I need to reorder data on the attached spreadsheet.  I need the Date and Amounts from View 1 to line up and look like View 2

View 2 has a date per record and the cumulative hours next to the date, …

729 views

Hello Experts,

So I have this Excel spreadsheet with formulas pulling values from a couple sheets.

The ISSUE :(  is that the table is not "dynamically" populating adjacent rows with related data…

940 views

Hi Experts,

Excel won't allow to break links...

Thanks

422 views

Hello Experts,

Any help welcomed as totally stumped on this Exc el conundrum.

I'm trying to concatenate values from the Details tab into [Column H] values of  [Column A]

For instance, if you …

737 views

Hi Guys, on the attachment, I have a macro which copies and pastes Values the sheet "ECB calc" to an attachment in Outlook and sends it .

However, when the recipient opens the attachment, there is …

220 views

How to calculate number of weeks in a month in Excel 2013? Below is the Excel table that I am using.

1235 views

I have a summary worksheet in excel I am trying to create, it is to be generated from a much more detailed server inventory worksheet. Within the inventory worksheet called 1-inventory I have a server…

1454 views

I am working on a project with many userforms with a wide range of controls (listboxes, textboxes, MonthView etc.) using Windows 10.

Once data has been added to the worksheet, the formula bar keep…

733 views
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Hi Experts

I have a data set which has got 190 Products arranged in Columns, and 4 Rows, which show the Value % Change over 4 different time duration respectively.

I need to do 2 tasks in this w…

341 views

Hi Experts

I have a data set which has got Two Columns, named - Product and Value % Change, respectively.

I am looking for some DIFFERENT METHODS which could be used for Ranking this data from 1…

344 views

I have a table of absences which is populated through a userform, I would like to be able to add command buttons or toggles to the userform to be able to search the records and edit or delete them. I …

2028 views

I have a big Excel worksheet with Name & Contact information entered.  It probably has close to 2,500 records.
I want to transfer all the sheet tabs into a new worksheet without certain columns and w…

733 views

Hello,
 I was wondering if anyone could help me with creating an array formula in Excel. I am trying to do a lookup on a value and sum the costs all in one cell. Attached is a workbook that has a sim…

1627 views

I created an organization chart in Visio 2010 from an Excel spreadsheet.
It shows the top level, but not the second level.
I have searched on the web, Visio Help, and tried just about everything men…

226 views

I have a list on Shipments that I need to match Description from list in Surcharges sheet.
Does not matter the order.

Shipments
A               B
tracking   Date
123           12/1/2015
.Surch…

235 views

Column A = Date
Column B = Category
Column D = Cost

I'd like to get a total cost of a given category in a given month. This is to itemize some expected expenses in a budget in order to better pre…

1038 views

Hi,

I'm looking to fix this formula so that it works as follows in google sheets:

Regex expression: \(.*?\)

Input: Jessica (M4KYYF)
Expected output: M4KYYF
Actual output: (M4KYYF)

Exampl…

826 views
Learn The Basics of Ethical Hacking & Pen Testing

Computer and network security is one of the fastest growing and most essential industries in technology, meaning companies will pay big bucks for ethical hackers. This is the perfect course to leap into this lucrative career, learning how to use ethical hacking to reveal ...

I'm looking for a solution to integrate a PostgreSQL database in my google docs spreadsheet.

My database consists of about 20 or so tables, some with several thousand rows.

The database is const…

136 views

I've included a spreadsheet that has some manually entered data on a few rows.  I've included text boxes on the spreadsheet with details concerning my needs for formulas.

I may be trying to get an …

827 views

Spreadsheet is attached with needed raw data already shown.  Notes concerning formulas are in a text box on the spreadsheet.

Would like to accomplish the needed tasks with IF STATEMENT, if possible…

637 views

Dear Experts,

Could you please have a look to the example in the attached file, basically there is a sheet named 'ProducedQty':


from where I would need an Excel formula in the B column of shee…

1146 views

Greetings to all;

First of all many thanks for the time to read my question, I've been reviewed in the forum but I have not had capable to find something similar, I have the following table:


a…

350 views

Hi Experts

I am doing some experiments in Excel Power Pivot Data Model and I am a total newbie in it. So I am not being able to figure out a method by which I can ADD Multiple Rows to get the Total…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS Excel
    (127,773)
  2. MS Office
    (56,832)
  3. VB Script
    (36,148)
  4. Visual Basic Classic
    (163,432)
  5. Office / Productivity
    (4,975)
  6. MS Applications
    (43,114)
  7. Programming
    (51,752)
  8. VBA
    (4,620)
  9. MS Access
    (214,897)
  10. Analytics
    (374)