Forum Widgets
Latest Discussions
Using Data Analysis tool pak to create histograms
Hello I am trying to create a histogram for the data on acorn size in mm for two collection sites. Site 1 is titled Creek, and site 2 is titled River. RIVER Site data is: 5.8 5.2 5.7 4.2 4.1 4.7 4.1 4.4 5.1 4.8 4.8 4.7 4.2 4.3 5.5 4.1 3.8 4.1 5.3 3.9 4.2 3.9 2.9 4.1 4.7 3.1 3.1 5.0 3.6 3.2 CREEK Site data is: 3.6 3.0 2.9 3.0 2.6 3.1 3.2 3 3.2 2.9 3.1 3.1 3.2 2.9 3.1 3.1 4.9 5.1 3.2 3.1 3.3 2.8 2.9 2.8 2.9 2.4 2.9 3.7 3.3 3.2 My question is how do I use this data with the data analysis tool pak to create a histogram. What goes into the input, and what would the bin range be? Please help I'm so lost! Thank you, James
copy and paste a range of cells and keep formula eferences
My goal is to copy a range of cells and have all the formulas in the copied range of cells pasted into a new location keeping the original formula references. I.e, I will have two identical data in two sets of cells on a sheet. E.g. one of the cells in the range to be copied might have a formula similar to, "='sheet 2'!K75". I wish for that formula to be pasted into the destination cells and be "='sheet 2'!K75".Sorting column groups having shared rows?
I recently organized a spreadsheet representing participants in a Ham Radio group. Though there is a base group of regular participants, we often have new folks joining us. I like to maintain a list which holds everyone's Call-Signs, first name, and state, so I can easily recognize infrequent members. I like to see the list (currently ~100, sample attached) within one screen, sorted by Call, so I arranged the data in four basic columns (Call, Name, State, Notes), then repeated the column group across the screen page. The problem is that as new members are added, their information cannot simply be added at the end of the list, then resorted. I'm trying to avoid having to move a long list up/down or typing in a Call and using the "LOOKUP" feature to get the member's info. Is there a way Excel can SORT BY "Call" only a group of columns, in this case four columns, without affecting data sharing the same row? Doing so would allow me to always have a Call sorted list, featuring four 4-column data sets, shown on one screen. I appreciate your help in advance.....I know I'll have other issues as our member list grows beyond one screen full!!!
linear interpolation of sparse data
I have several lists of data, each sampled at different varying intervals. I want to merge them into an average set of readings, but since they are each missing data and have readings at different times, I need to first fill-in all missing data using some (linear) interpolation. For example; I want to merge all three months of data into one average month summary: 1-Mar 0 3-Mar 2 10-Mar 8 14-Mar 11 17-Mar 14 21-Mar 14 24-Mar 19 28-Mar 22 31-Mar 33 1-Apr 0 1-Apr 0 7-Apr 2 11-Apr 2 18-Apr 3 21-Apr 9 25-Apr 10 28-Apr 14 30-Apr 14 1-May 0 5-May 3 9-May 4 12-May 8 16-May 9 23-May 13 26-May 16 30-May 17 31-May 18 1-Jun 0 1-Jun 0 6-Jun 3 9-Jun 7 13-Jun 9 20-Jun 15 23-Jun 19 30-Jun 22A problem: convert Arabic pdf file to Excel make strange letters
Hello, I've to convert a pdf file into Excel file for essential task in my work but unfortunately the arabic letters changed into strange letters and symbols as shown. Please help me to fix that. Alhamdulillah, the problem 's been solved. For anyone that may face such issue This is the way I used : - convert the pdf file into an Arabic word file through an online convertor that "supports Arabic Language" (not Adobe) - copy the table contents -in word file- to a new blank excel sheetBraille Translator Challenge
Using the Braille Alphabet lookup table provided: Part 1 - convert the given phrase from Braille to words. Part 2 - convert the given phrase from words to Braille. ✅ Solutions should be in the form of a single-cell formula. ✅ Generalized Lambda functions are welcome, provided the function definitions are included with your solution. ✅ Keep in mind, the "best" solution is not necessarily the shortest... Strive for conciseness, if you wish; just don't let your solutions be ordinary. 😉 Good luck and have fun!
Excel text box overlay- what is it, how to remove?
I have this box that has somehow been inserted into my table. There are underlying cells and I can actually scroll right under this box and also access the cell underneath it. And I can type about 140 characters into this box. Deleting surrounding rows or columns does not affect the box, so it doesn't appear to be correlated to a specific cell. There is no context sensitive help when in the box and almost all normal excel functions are greyed out when I'm in it. Any help is appreciated.
Entering 24hr time values
Hi, My user wants to be able to enter 24hr times as "0900", "1245" without any other punctuation and have them convert to (or at least, be interpreted as) valid 24hr times (e.g. 09:00, 12:45). I can't work out how to do this. Just setting the Cell number format to "hh:mm" doesn't do it: it requires the colon to be typed, otherwise it interprets the input bizarrely and only displays 00:00. I would appreciate any suggestions. Many thanks, ColinWelcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
