SQLCell is a magic function for the Jupyter Notebook that executes raw, parallel, parameterized SQL queries with the ability to accept Python values as parameters and assign output data to Python variables while concurrently running Python code. Is there a limit? I couldn't find one posted. This number of rows can be saved in the default format that version of Excel supports (e.g. However, you will not necessarily be able to save in the older XLS format, which is still limited to 65,536 rows.
Hello All I wonder if you could help with this one, I have a list of data like this (no spaces or other characters) JN551122B What I need to do is split each of the characters in to its own cell if JN551122B was in cell A1 I'd want to return: B2 C2 D2 E2 F2 G2 H2 I2 J2 J N 5 5 1 1 2 2 B The nearest I have got is the right function, but it brings over the preceeding characters, and I need each character in its own cell. Hopefully I could copy/paste a formula and change the reference for each cell value, i.e. 1 would return J, 2 = N, 3 = 5, 4 = 5 etc. Thanks for your help! Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet.
I am running Excel 2011 for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data. I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears.
Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions. I just worked with a data set where I needed to create a unique key based on existing information where no unique key was set up as a field.
I accomplished it by concatenating (using the & concatenation operator) several fields based on what I hypothesized and observed about their content. I'm thinking there has to be a more automated way to discover the best unique key of existing fields and their data. I thought I'd post this as a challenge because I don't know the 'right' (or better) answer. Anyone have any ideas? Hello, I am new to using Excel and I am not very computer literate. I am looking for some help with a spreadsheet I am making. Here is the problem: I have a column of 14 numbers in cells A1 to A14.
If all of these values are less than 2%, I would like a 'Pass' to display in cell B1. If any of these values are greater than 2% I would like a 'Fail' to display in cell B1.
I have got a formula that works for a single cell but I can't figure out how to get it to apply to more than one cell. For example, I have entered =IF(A1. I recently moved into a new office and I am using a brand new computer on our network. When trying to edit an existing file, I'm not able to select a single cell and type. After clicking on a cell, if I move the mouse at all (even without pressing the left button) it just continues highlighting cells no matter where I move the mouse. I am also not able to click on the tool bars at all. I have to actually Ctrl-Altdel to get out of the program.
![]()
I'm sure this is something simple, but I don't know that much about this program. Any help would be greatly appreciated.
I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on).
Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar.
I am extremely confused, can anyone help? Hi all, I have several accumulated values from other spreadsheets on my spreadsheet and I'm combining and organizing them on mine. However, the cell alignment isn't working properly as you can see in the picture below. Now, I can certainly retype these values and align them and they'll align all nice and neat; however, I have a huge Column and retyping that column would take an inordinate amount of time. I searched earlier on cell alignment and couldn't find anything.
Any help is appreciated. Sincerely, Bill. Here's my question.I have a list of numbers and I want to know how many combinations (and what they are) of adding the numbers will equal an amount. List of Numbers 1 2 3 4 5 6 7 8 9 10 Amount to be reached = 12 These are some of the possible combinations to reach 12: 2+10 3+9 4+8 5+7 3+4+5 6+3+2+1 Is there a function in Excel that will do this for me? I want to know which numbers (i.e. Cells) can be added to reach 12.
AND, if possible, colorcode the cells added for each combination. Good luck and thanks!! I am trying to automatically capture and record the date of a cell's last change in value (date stamp).
I have an item price list and if a particular cell gets updated I want to automatically record the date of change of that cell. I realize that after I change cell A1 I could tab to cell B1 and enter Ctrl+; but if I have a hundred new prices to enter I don't want to do that (plus me or the data entry person might forget). For instance, A B 1 $32.17 8/17/08 2 $43.20 9/12/09 If I go in and update cell A1 to $33.98 today I would like cell B1 to read 2/16/10. But I don't want cell B2 to change.
(Founder, ExcelUser) Sep 11, 2013 Although I haven't used Excel on a Mac for years, I think you should be fine with Mac Excel. First, I sell some fairly advanced Excel dashboard templates, and also an ebook about how to create Excel dashboards. I've sold a lot of them, in nearly every country in the world. But I've.never. had a request for a refund from a Mac user because my products didn't work on a Mac.
Because of this experience, I feel safe in saying that virtually anything I can do in Excel worksheets on a PC others can do in Excel worksheets on a Mac. (However, there.might. be some minor inconsistencies with VBA between PCs and the Mac because of differences in the two operating systems.
Dunno.) Second, I have a friend who's a very opinionated Excel MVP. He purchased a Mac about six months ago so he could better support a client. If he had found inconsistencies between PC and Mac Excel, he would have whined about them in our private Excel MVP forum. But he's not written a word along those lines.
Hope that helps. (CFO, Solstice Mobile) Sep 11, 2013 I made the switch from PC to Mac about a year ago and although there are some nuances to running Excel on the Mac verse a PC, you will get used to it once you learn the shortcuts as you probably use on the PC. Keep in mind if you are using any current features in the latest version of Excel for Windows that they might not be available on the Mac since they seem to be a version or two behind but I haven't hit a snag yet. The overall reason why I like the Mac now is that it's just a more intuitive system and things seem to just work! (Consultant, Independent Advisory Services) Sep 11, 2013 I've been using Excel on Mac for years. The main lack I find is the absence of the statistical analysis tools (analysis toolpack, as I recall). These can be had through third-party add-ins or separate tools.
They were good, usable, and quick but not great in regular Excel. Otherwise, I have not found anything lacking that made me feel like I had a lesser version of Excel.
I made the switch to Mac purely for productivity reasons. I needed to spend less time working on computer problems and more time using the tools for actual work. The productivity gain was SO much more than I expected. (Treasurer and Board Member, Partners in Performance Excellence (PiPEX)) Nov 1, 2013 I've been using Excel on a Mac for several years (actually since 1984 when it was called MS Chart) and find it very capable as a replacement for Excel on a Windows computer. That said, another way to go would be to run Windows via Boot Camp (or Fusion or Parallels) and use MS Office there if you have other apps that require Windows. I have been using Boot Camp with Windows 7 Pro on a MacBookPro 2008 variety and, up onto the Intel Sandy Bridge/Haswell processors, it has been my fastest PC using Office. (Director, Strategize Financial Modelling Inc) Nov 1, 2013 I was faced with this challenge over the summer.
I am a MS Excel user, whilst my client's executives & personnel were all on Excel for Mac. Given the nature of the financial model mandate for the client, I was forced to customize the spreadsheet via VBA macros, in order to patch up certain MS Excel features that currently don't exist on Excel for Mac. I documented my experiences via a blog 'Financial modelling techniques between Microsoft Excel and Excel for Mac' on my website.
The features to watch out for were namely: ● ActiveX macros won’t work on a Mac ● Data Analysis Toolpak is not officially supported currently ● Inserting Adobe Objects in Excel for Mac does not exist currently, and ● Referencing the User Name property in VBA script won't work either. (President, Infiniti Films, Inc.) Jun 30, 2014 I was originally a Mac user (Mac IIfx with a blazingly fast 33 mhz processor). Switched to Windows in the early 1990's because the Mac and Windows command structures weren't the same which meant that, for instance, print macros created in Mac Excel wouldn't work when I sent the tile to a Windows based client. However, I was spending far too much time in compeer hell working on Windows IT issues, so when the Intel based Mac's came out, I switched to a Macbook Pro and ran Windows through Parallels.
It works perfectly. When I need to use Excel or Quicken, I switch to Windows.
Everything I do that is internet related I do on the Mac side (reducing if not eliminating the virus issues that were such a time suck-even with the best anti-virus software installed).
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |