Getting data from Snowflake to Excel
Hello I have multiple no technical users and am trying to find a way to setup a snowflake query for them and then let them refresh it whenever they want or on a schedule, but I couldn't find a good solution this what i found so far: ODBC (Not great for non technical users needs setup on each user desktop) Power Automate (Needs Power Automate Premium which we don't have) Third Party tools (Expensive pricing models) Through Power BI (We want to separate this process from power bi) Any suggested solution please!
Auto fill cells depending on another cells content
I'm OK with Excell, but by no means an expert. I'm creating a sheet that will calculate gas purge volumes, and I've got most of the cells sorted with calculations based on other cells, but one of them is giving me a headache. It's probably simple for those with experience. So... I have cell E2 which contains a drop down list (linked to another sheet) which gives options (which are meter sizes) E6, U6, G4, U16, etc. What I'm trying to do is get the column F2 to auto fill depending what is selected in E2. So, if someone selects meter size U6, cell F2 will auto populate with the number 0.0028, if they select meter size E6 then cell F2 will auto populate with the number 0.008, etc Sorry if the use of E6, U6 etc complicates things, those are the actual names of the meters. Any help is greatly appreciated.
Why is Excel suddenly calculating much slower than before?
I've noticed that one of my workbooks has become significantly slower over the past few weeks. It's around 20 MB, contains several PivotTables, XLOOKUP formulas, and conditional formatting. Simple edits now take a few seconds before Excel responds, even though my PC isn't under heavy load. Has anyone experienced something similar? Are there any common settings or features that typically cause this kind of slowdown? Any suggestions would be appreciated.separate columns in excel (imported from .txt file)
Hi all. I have a a table to bring in from a .txt file lots of lines with an excerpt below. I have tried to import data and copy paste etc and then tried to separate columns using delimiters and also number of characters but there is no consistency in the numbers in the columns, it keeps separating different rows differently (ie if i use space the title of the object on the 2nd row may have two or three words so using space as a delimiter is out, same for the number of characters and position). Any suggestions - is too much data to try and clean up by doing one of the above then trying to tidy it!
Help needed to filter in Excel please
How do I filter our spreadsheet to populate a list with only lines containing the search word? For example: 18598-Ensign, 6 - 3 POSITION TIE LUGS, RIG 141 18599-Ensign, 6 - 3 POSITION TIE LUGS, RIG 143 18600-Savanna, REPAIR JACO CATWALK SKATE ASSEMBLY, 653 18601-Savanna, REPAIR BAIL TILT CYLINDER, 653 18602-NS Modular, 8" LTC, 6PCS And I only want to see "Ensign" jobs. Thank youOdd pasting of things as images
This just started on specific page of one specific workbook, but now happening on completely new workbook. If I select a cell and copy and paste it puts it as an image in the cell. If I right click to paste I dont get the usual choices of test, formula, format etc I just get paste picture in cell or paste (which pastes an image) I've done a full reinstall and now it seems to be alternating between normal copy and copy as image if I do Ctrl C. The clipboard shows an image and then text in the history. I've disabled all com addins except dropbox. Driving me nuts as been getting slowly worse over last few months. Any ideas appreciated
HELP WITH EXCEL
Struggling to do a simple transition in Excel if anyone can give some advice: I have 3 items I need to run up & down instead of across... is there any easy way ??? So I need the Name and two of the xx Boxes to run from top to bottom... I did the first two but I did them cell by cell.... is there a formula that will take the entire thing and create what I need? Adriana Zaragoza Lopez Alejandro J Escobedo Alyssa Christina Amber H McCord Ana C DePaz xx xx xx xx xx xx xx xx xx Adriana Zaragoza Lopez xx xx Alejandro J Escobedo xx xx
