real

So I have been having this same problem for a long time. I just work around it, by scrolling with my mouse, which can be tedious. We used to have MS 2016, now we have Office 365. Problem existed on both. The document is a shared document, old school, not the internet sharing because I need to be...

Hi all. I prepared a small example database but it seems that I'm not allowed to post an attachment so I'll try and explain my dilemma by using one of the above tables. <tbody> A B C D E F G etc etc etc etc 39 6 23 34 2 7 26 8 3 35 18 22 7 23 2 39 6...

Hi, I've been coding in VBA with Excel's built-in events for the Workbook and Worksheet and their usefulness is very obvious. However, with custom classes in VBA you can also create your own events -- and raise them -- to other objects that are listening for those events. What's unclear to me...

When I enter the following data into Excel and generates af Forecast Analysis with a Polynomial Trendline (Order 2) Excel shows an almost perfect trendline in the diagram. But when I choose Display equation on chart, it comes up with a Trend formula that has nothing to do with reality. This is...

Hi, to all members of this great forum. Crossposted : https://chandoo.org/forum/threads/total-by-puestotrabajo-wrong-calculation.41915/ The idea of ​​the table that I present in the file is to distribute a quantity of KG of production in several Puestos de Trabajo, through participations. I...

Hello, In column A I have the scheduled date for a task to be done. In column B I input the real date of task when it is done. In Column C I want to reference the real date if entered, or if real date is blank reference the scheduled date. Can someone suggest a formula please? Thank you!

Morning All First, apologies if this is already answered in the Forum, but i could not find anything similar I have a very large data set in excel with 1000's of rows and i cannot uses simple filters as this is not appropriate to generate subsequent reports from the data, therefore i have to...

I use a web site to monitor when my son gets dispatched on a fire call https://www.toronto.ca/community-people/public-safety-alerts/alerts-notifications/toronto-fire-active-incidents/ I have a macro that works fine on my Windows 8 computer but not on Windows 10 and no one in the world seems to...

I am trying to write either a formula or Macro to find the last space in a string before the 38th character. My problem is that my data is not standard and I don't want to truncate in the middle of a word that falls at 37 characters. See example below. <tbody> Free-bird Real Opportunities...

Seems there's always trouble with date values. Maybe it's more frequent in non-english countries due to locale settings? I don't know, but either way date conversions is a real pain. I was sent an excel sheet from a colleague at work today. He has date as text a cell ...let's call it cell1. The...

A1 = 4 B1 = x A2 = 2 B2 = y A3 = 7 B3 = z I need C1 to look like this xxxxyyzzzzzzz this is a simple example. my real data as 200 plus rows. I was going to use rept(B1,A1) & rept (B2,A2 etc.... but that's taking too long

I'm having trouble figuring out a way to keep subtracting real time inventory (Column D) for part # AA as it continues to show up on a production schedule. Any ideas on a formula considering part AA may show up multiple times on a schedule with 500 other part numbers. Thanks for the help A...

HI I am trying to produce a simple spreadsheet whereby I can monitor if staff working alone are overdue to phone in to say they have finished and are safe. All I need is a column for time due to finish and another column that shows time (hrs Mins) elapsed. If that could change colour after...

Hi there, I would greatly appreciate any help - I have been trying to solve this all day! I am trying to count all the instances that a real number in columns C/E/G/I/K/M/O is paired with a real number in column D/F/H/J/L/N/P, respectively. In this example, the count would be 28. An example of...

Hi Where can I find excel files which has raw data need to be cleaned/formatted etc, remove duplicate, blank cells etc. I want to practice that on real life files. Is there any website I can down load these files from? Thank you very much.

Hi Someone showed me a real life excel files. It was imported from database. The file needs a lot of formatting, cleaning, blank cells, pivot tables etc. I kind of found it so difficult to deal with. I do not think I will get a chance to work on these kind of sheets. I wonder if there is a real...

I use a workbook A containing lot of data. Then, WB B reads from WB A, and WB C reads from WB B. (ABC in same folder) When I open up WB C, it asks for Update / Don't update. If I don't update, the file opens normally. But when I do update, something strange happens: in VBA Project explorer, it...

Hello Experts I would like to sort my excel data from Left to Right and the range is Q!:AD200 from largest to smallest. Anyone knows how to write this VBA could for me? I would to be in real time i.e. the moment a data change the sort will start. Thanks

Hi Guys, Firstly, apologies for the total lack of a snappy title... I have a job interview next week in which i will have to show how i would handle receiving responses to certain questions on a questionnaire. My idea is to Randbetween and Choose(Randbetween) to give myself a real working...

Page 1 C372)Ag Non Real Estate C374)City. D375)#loan E375)Balance C375)Ag loan. C376)Ag line Page 2 A1)Ag Non Real Estate. B1)City. C1)Product. D1)Ag loan. E1)4. F1)$480 Ag Non Real Estate. City. Ag line. 3. $350 (same layout as first record) How do I bring back the count and dollars to page...