Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Spreadsheets

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have an excel spreadsheet that if something is selected in a dropdown in cell D10 then E11 will be disabled
0
[Webinar] How Hackers Steal Your Credentials
LVL 10
[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.

I am sure this is a simple fix, but I cannot figure out how to get the scrolling window in the attached worksheet titled - Dashboard -  of the attached workbook to stop when it reaches the bottom of the referenced range.  Please see the attached screenshot also.

Thank you for your assistance!
Screenshot.docx
NCCU---Contracts-Inventory-Listing-.xlsm
0
Hi,

I have a dashboard created but wish to link some of the information to the data behind it, for example, showing on the front sheet  I wish to look at points 6-11
1) Overdue tickets - done
2) Open Tickets - done
3) Problem tickets - done
4) Completed tickets - done
5) Unassigned tickets - done
6) The person who has been assigned the tasks most often - support on this
7) Which user has reported the most tickets - support on this
8) How to check your ticket (based on the data in the IT Action List) - is there an easy was of a user clicking on a button which then displays the tickets they have reported
9) Top 5 categories reported (number of instances) - chart
10) Top 5 subcategories (number of instances) - chart
11) Open tickets by category - pie chart


Kind regards, Stewart
IT-Log.xlsx
0
I had this question after viewing Extract Unique Values From Multiple Columns In Excel.

same spreadsheet, how can i get the number of unique count. somethign like   sum(1/countif  i could not get it work.
1
please see attached.
E.xlsb
0
I had this question after viewing Excel Formula Lookup every word in single cell and match it with another cell if found the return the next column..


 Ejgil and Neeraj helped me on the formula of lookup. but there is something which does not work now.

please see attached file. i would appreciate your help.

A.pngMatch-word-Flora1.xlsx
0
I have a large number of spreadsheets in my excel file.  I would like to be able to take a group of the spreadsheets and minimize them so that it is easier to separate them into groups.  Is that possible to do in excel? Thanks for your help!
0
I have a user who created a Word document, and embedded several Excel spreadsheets (XLSX) as Objects. When this user opens the Word document, the XLSX files open correctly. When another user opens this same Word document, the XLSX files are seen as Unknown Objects, and do not open. Within this same Word document, there are embedded Word documents (DOCX). These open fine for anyone. It is only the spreadsheets that are an issue.

I have seen this issue myself as well. I attempted to open the embedded Excel spreadsheets with the same result; Unknown Object, and will not open.
0
Hi,

I have an excel document that has number rows and columns and it is presented in a standardized format. Each cell has a very specific formula and tends to be either hard coded and wrong or missed and wrong.

I am curious if it possible to prevent users from adding and removing rows and columns and then add a dropdown button to add rows and another button to add columns

Each of these buttons would be placed at the end of a range.

Hopefully, these buttons would, when click, copy the formulas from the columns/rows within the set range and append a row/column at the end of the range
0
I'm running win xp,How do I Recover Excel Docs infected by (fEstasAzulCorrupta)? without deleting them.Very important spreadsheets.
0
Free Tool: ZipGrep
LVL 10
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Hello,

I have 9 columns, What I want to say is:

If column "H" is blank and column "G" is populated, make column "B" turn RED.  Is that possible?
0
Good Afternoon

You will see on this sheet that I have a 'Statistics - Made' table which shows 'Pure Bristle', 'Mixed Bristle' and 'Nylon'.

Rather than me spend time each month recreating the formulas for each month, I would like the table to automatically populate with the relevant numbers for that month.

- Pure Bristle = B1, SB1, B2, SB2, B3, SB3, B4, CB4, EB4 and SB4
- Bristle & Nylon = BN1, BN2, BN3 and BN4
- Nylon = N1, NU2, NG2, N3, N3 and N4

I would be grateful of someone's assistance on this matter.

Best Wishes
0
Hello Experts,

I have 2 master tables:
1- (Student: Student ID, Student Name)
2- (Course: Course ID, Course Name)

And have a third table that combined the previous 2 tables called (Student Registration Table) and contains 4 dropdown lists: Student ID, Student Name, Course ID, Course Name.

I want to build up an excel sheet for this combined table (Student Registration Table) so when I add a new record and select both "Student Name" and "Course Name " 
the "Student ID" and "Course ID" dropdown lists will dynamically look up the corresponding ID's respectively.

Note: Student ID & Course ID dropdown list shouldn't be editable.

the Idea is explained below in the Image as well and sorry for my bad English.

Needed Tables

Thanks a lot in advance.
Harreni
0
Hi,

I have one spreadsheet called Q-Test.xlsx that contains information such as

serial no, product, ship date, colour, customer name, details

I also have several other spreadsheets all very similar but for each product. For example product AB12 that is contained in spreadsheet AB12.xlsx

This also has data such as serial no, product, ship date, colour, customer name, details etc etc.

What I want to do is enter a date into the ship date column on the Q-TEST.xlsx spreadsheet against for example serial no 12345, and this date is automatically populated on the AB12.xlsx spreadsheet against serial number 12345 if it exists.

I have looked at multiple forums and suggestions online regarding VLOOKUP but cannot for the life of me get a result other than #N/A which I'm lead to believe means the data can't be found.

If anyone out there can offer a solution I'd be very very happy to listen to it as the googling is getting me nowhere.

Many thanks in advance.

Steve
0
What I want is a when dropdown is selected it sums up those hours.  For example.

If ST is selected then it adds up all those hours from Saturday thru Friday and if OT is selected than those hours are summed up and DT in column C.

On the attachment in the cells that are yellow it adds up the hours for whatever is selected either being ST or OT or DT.  I wanted the hours in the yellow cells summed up based on what is selected.
C--Users-lfreund-Desktop-TIMESHEET.xlsm
0
Dear Experts,

I have two different users working on the same workbook/spreadsheets (attached), resulting in two different versions.  Could you please show me a way to merge these spreadsheets/workbooks together without overwriting the data by copying and pasting?  Thanks.
Sample-A.xlsx
Sample-B.xlsx
0
I had this question after viewing Count number of times a value appears.

I need a space between the concatenation string below but only if there is content to begin with in I2 and J2.

=concatenate(I2:J2)

Open in new window

0
I need to count the number of times that a text string is repeated in Column I of a google spreadsheet and produce that count for each row in Column J.  

Here is a visual screencast of what am trying to accomplish in sheets.google.com.
0
The attached is a spreadsheet of accounts sorted by last name.  There are 3 named ranges, Split 1, Split 2 and Split 3.  Split 1 for instance refers to cell D520 which is at the last row of names beginning with F.  Split 2 is at the last row of names starting with N. And Split 3 is at the last row of Z's.

If you jump down to the named range Split 1 you will see a formula that counts the rows between the first row of names beginning with A and the last row containing N's.  The reason for the indirect function is so that if I drag Split 1 either up or down it dynamically counts the rows from the first row of names to wherever I drag it.  This dynamic formula works well.

What I would like to now is to create a formula that dynamically counts rows between Split 1 and Split 2. Essentially this formula would count names G-N, but if I drug it down to the end of the O's it would adjust to count the rows G-O.  And finally I need a similar formula which dynamically counts rows between Split 2 and Split 3.  

I hope this makes sense!  The concept is simple enough, but It's hard to explain.
0
On Demand Webinar: Networking for the Cloud Era
LVL 10
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

I would like to find matching values in two columns and add the adjacent values
Book2.xlsb
0
Good Day! Please help how should I do this, If column Product contains "PO" OR  column Size contains "0MX" the status will be Approved else Disapproved. See image

Capture.PNG
Thank You and God Bless all!
0
In a specific cell, i contatenate some text with the now() function (french = maintenant)
I want in fact the month, like september to be displayed based on now()
Which function does that translation ?
Thanks
0
need a formula or macro to get this results (see attached)

tricky but i need to get those differnt numbers between the slashes
Book2.xlsx
0
Per the attachment I want to change the value of a cell based on the value from another sheet.  Also wanted to mention that the data is linked to access and updates on open.

So for example per the attachment:  on rows 7 thru 12 on column H that is highlighted I wanted the NO's to be YES since the base number (number without the dash) on the CTF_ALL sheet has a Yes.

So if 930-45588-1 on the OPEN_REQ_PLM_COMPARE  is NO but on the CTF_All Sheet the base part number 930-45588 is a YES than I wanted the NO's on column H (one's highlighted in yellow for example) to be converted to YES's.

I have many thousands of lines so that's the reason for the request.
C--Users-lfreund-Desktop-CTF-REVISI.xlsm
0
User is receiving an error message "Microsoft Excel is waiting for another application to complete and OLE action.
The user was in an imbedded spread sheet in a work doc or trying to embed a spreadsheet in Word. They exit Word, the error message appears as a delayed action.  And it keeps popping up even though I do not have any excel spreadsheets open. Sometimes they can't get rid of it unless they reboot. This situation happens randomly. It does not happen all the time.

Anyone familiar with this error? Have a fix?

DLH
0

Spreadsheets

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.