Search Results for ‘excel’

Within a single data table, I am using the following LOOKUP calculation to locate the last occurence of a "text string" in a range from Column M, then report a "date" from the associated cell in Column B. Column B is in date order, past to current, top to bottom. The result of this calculation...

Hello, i am facing this error message while opening attached excel file "excel cannot open the file mysheet.xlsx because the file format or file extension is not valid" it is very important file for me, i will be very thankful if anyone can help to open. Thanks

I have created a PDF from a spreadsheet tab. The sheet appears fine in print preview mode but when either printing or saving as a PDF certain cells appear very small and unreadable. The cells in question contain text. I have ensured I have the latest Adobe version. Any suggestions? Thank you

Hi. I have Word, Excel, Google Docs, Google Drive, OneNote and OneDrive downloaded on my iPhone. Can I safely delete these apps from my phone or will the files on them get deleted as well? Should I sig out or can I directly delete them from my iPhone? Thanks in advance.

I very often get two dimensional arrays of returns for a given fund, months across the top and years down the left side: Jan Feb ... Dec 2019 1% 2% 1% 2020 2% 1% 3% This format is useless to perform analysis, so I will typically...

Dear members, I'm having a lot of trouble with this VBA code for a table that has rows starting from 341-533 and columns A-K. I'm trying to write code that enters a specific string criteria in a text box to search for a string like "rent" or "volunteer" in a multiple detailed string column like...

I want vlookup or other formula for my sheet. When i enter class Name "One", "Two", "Three" etc. All students Names of that particular class appear in a list.

I have forgotten the password to an Excel spreadsheet that I created and own. There are 6 keywords that might have been used to create the password, but I can't remember which ones were used or the combination. I may have used capital letters and punctuation marks, but I am not sure. I have...

There's sharing as email attachment option on excel, I have connected my Gmail to the windows mail by Mail in the control panel. But when I share an Excel file via email it didn't send. Any solution for this?

Im looking to transform data output into a matrix. The data - continous table: Date Names Topics 1/1/01 Tom;Dick;Harry topic1;topic2;topic3 7/1/01 Dick;Harry topic1;topic4 The matrix required: Topic1 Topic2...

Hi! :) I'm using a Huawei Mediapad M5 lite and I'm unable to delete an excel file that was saved to the device. I can see the file using the File option in Excel, but when I try deleting it I get a "Not Allowed You don't have permission to delete this file" message. (it is a read only file)...

Hi, thanks for looking. I need a way to search a workbook and replace the character "\" with "/" a normal search and replace isnt working for some reason. Reason behind it: i want to house interlinked workbooks on the sharepoint. links to documents in the same or sub folders migrate just fine...

Tech Support Guy System Info Utility version 1.0.0.9 OS Version: Microsoft Windows 10 Pro, 64 bit, Build 18363, Installed 20190620212503.000000-480 Processor: Intel(R) Core(TM) i5-2500 CPU @ 3.30GHz, Intel64 Family 6 Model 42 Stepping 7, CPU Count: 4 Total Physical RAM: 8 GB Graphics Card...

I have an Excel spreadsheet that is always open. I want to use Visual Basic in MSAccess to execute an Excel macro based upon certain conditions in the MSAccess database. I can use Auto Open to run the macro from a closed Excel Spreadsheet from MSAccess by closing it and then opening the...

I am using a mac, Excel 2016 (not sure which version). I have multiple graphs and have added text boxes and lines/arrows to chart. When I try to move one of these text boxes or lines, it bounces back to the original position. These are not grouped. This is happening to some users in my office...

Hello- I have a recurring issue that when I work remote using my HP laptop (remoted in to my office network or not). Every time I work in excel or word these files will become unresponsive. They are not large files. I have also tried working off my desktop and not remote in to the network, but...

Hello, I have almost 500 lat and long coordinates in an excel sheet that I need converted from their current state (excel) into gpx so I can load into a marine GPS. Does anyone know how to convert these or a program that can assist me? I cant imagine spending 3 days manually entering them...

Team... I'm new to this tech support web... I have zero knowledge on VBA, can someone help me out... I need to automate the attached excel and to send reminder email to colleagues when the due date met. New column will be added frequently before the next due column (currently "AK") The...

Hi guys! My problem is that I can't paste anything to ms word, not a text or a picture from the clipboard. If I press ctrl+v a symbol appears from a new font what I installed earlier and used. I tried to reinstall but it didnt worked. The copy-paste command works in excel and in other programs...

Mornin' all.... Before we begin, I truly know all about page numbering in Excel. So I do not need any instructions about the usual way to do it. Got that down, 100%. Been doing it correctly for years. At my job I do statistical data modeling. I end up writing a memo for the non-math people...