Search results for query: *

I'm just sending this as a test. I can't find out where my group is and I'm hoping this is the location for Excel questions. If so, I'll bookmark it specifically. I'm lost with this new format... AI has infiltrated? GRRRRRRRRRR Change is a 4-letter "C" word. I mean really, I've been using...

Hi there, Please see attached the starting of a Temperature Chart showing the Average temps for each day of every week of the year (2024). It is a pain, in Column B to enter the dates manually. I tried with the "week" and "weekday" functions but I'm lost. Not the RESOURCE link, this is for...

I have an app on my android phone that is a "Just the darn checkbook" type of app. Easy Peasy... but it has not had support since 2015... it has worked perfectly without updates or what. NOW... Android is trying to HELP US, and all of the security updates to the OS, the "backup" and "export"...

Calculataing data from a "Table" on one worksheet to another. (I'm still learning how to work with "TABLES". SAMPLE SHEET ATTACHED! I'm usually pretty wordy so I've done my best to minimalize what it is I'm seeking to achieve. Please see the Designer Tab for a repeat of the information below...

NOTE: I submitted this one with a file attachment and hit Submit, but it didn’t show up. This is a resend. I hope it doesn’t become a duplicate. I wish I knew more and didn't have to bother y'all but here I am again. I have attached a sample spreadsheet. What I am ATTEMPTING to do, is...

Hello, Its me again. I have a checkbook app that will export transactions into a *.cvs file but the date column is so contrived and the app (Android App: "Checkbook" by digitallifesoftware@gmail.com is no longer on Google Play, or supported. It is the most simple checkbook app I found back...

I am new to using the Insert > Tables option to my spreadsheets. WHAT A BLESSING (Skip [smile]), but I'm having a nagging issue. I have the default font under OPTIONS in the app to use "Tahoma 8" and my table is perfect in that regard, UNTIL, I enter new data to create a hyperlink. When I go...

A previous question on this workbook was SOLVED regarding =SUMPRODUCT() and you can find that information in this thread: https://www.tek-tips.com/viewthread.cfm?qid=1821455 PERFECT SOLUTION: =SUMPRODUCT() formula that I had no clue about (Thanks Skip Vought .. and all the others who...

#1. I do not know VBA or how to use it, so there's that. #2. I think this might be a pivot table thing, but its been over a decade since I've done those and quite frankly it was rather hit and miss. SO here we are.... On Sheet1, currently has just over 5,500 records (and growing). Column A...

I'm not sure how to ask this but here it goes. I have Microsoft365 and am editing a document containing, a crochet pattern. Its a data dump from a designer to provide all instructions in a written form to help decipher a chart. Below is an example showing the data dump...

I have a checkbook app that I use on my android phone which will export to a *csv file. The exported data lists the date for each transaction as shown below: Mon Dec 15 16:42:27 CST 2014 How can I convert the date to show without the time stamp, just the date. I am trying to match transactions...

First, I saw a question regarding Outlook posted earlier but I'm not sure how much support is given here to Outlook information other than Email support. If this is not a proper place to ask this question, please say so, I'll not be offended and will stop the thread immediately and delete if...

My PDF files open with the Bookmark pane open ALL the time. How can I configure the application so that by default, the bookmark pane is closed and only opened when selected to open. I've found tweak information via google search but NOTHING I've found/tried has worked. I sure hope SOMEONE...

I must start by saying, I retired 7 years ago and what they say is true "If you don't use it, you lose it." That said, I do remember basics but never did know much about VBA and fancy tricks. All I learned regarding the major nuances with Excel, I learned from this GLORIOUS resource. I...

This has got to be simple math, I've been retired 2 years now and have lost so much of my know how...can you please help. I am TRYING to create a formula that shows Profit/Loss on selling some items but if I use the formula that I have, it does not show negative... but oh this is going to be...

I am using 2010, hubby refuses to upgrade or get the conversion program so I'm stuck saving my work as an XLS file rather than XLSX, due to the differences, not all features of 2010 will work when saving a file due to compatibility issues. That said... I have a list our movies... some DVD and...

I am working on an inventory of DVDs and Blu Ray discs. I have a running time column that shows the time as, for example 97 minutes. I want a second column that shows it in hh:mm or 01:37. I have been out of Excel for a few months (9 months) and I'm sure this is so simple but you now how it...

I am having a COMPLETE and utter mind melt going on.... I am trying to create a workbook "Template" that shows Accumulative Totals... caveats... 1. This will be a weekly report, new file each week. 2. On table will be the input table for the previous week (its a Monday report done on the...

I have been maintaining a spreadsheet for YEARS with hours of operation anywhere from 7:00 AM to 11:00 PM with no problems... Subtract login time from log out time and there you have it. (Skip if you answer this, don't tell me the ABS is the solution AGAIN :)...) So if I have someone log in...

I am adding several pages from 3 worksbooks together. In doing so, all of my conditional formatting is gone. In older XL versions there was a way to import the COLORS form another workbook, but I have no recollection of how to do this.... HOWEVER, is there a way to import the conditional...