I create a lot of “tools” in Excel. Rather than call them something basically like a “workbook”, I give my creations names. Like Generator or Summarizer. Is that weird? Labeling things a “workbook” this or that doesn’t give the things I create justice…particularly when they don’t need you to do work in them. They take someone’s work inputs and generate outputs which is why I think of them as tools that deserve a name as if they are some type of fancy software haha ..read more

I am using Excel 2021. In the attached workbook, I want to count in column A (Product) Savings Account and Guardian account in one total under Savings Account on the Total Worksheet column B. I tried combining using a countif statement between the two, but I could not get it to work. Then in column C (Risk) on the total worksheet, I need it to count for Savings account and guardian account the total count of cells that has data in it. Attached Files test data.xlsx (9.5 KB ..read more

I have my data on a spreadhseet. Colomn B has the dates of the year going down vertically from 1 Jan to 31 Dec on a daily basis. My graphs show 'odd' dates. I would like them to show simply 1 Jan, 1 Feb etc (or something similar) Examples of what I am seeing are below: Attached Images Graph 2.jpg (131.9 KB) Attached Files Energy.xlsx (128.0 KB ..read more

Hi everyone, maybe someone could help me! I'm trying to identify the classname related with each string named "toSearch" in each URL. My logic is to loop every link and search for a text that is present in each level especified. With my code below I'm able to identify classname of level1 and level2, but is not working for level3 and level4 and the other issue is that some cities don't have more than one location, in that case level4 exists but level3 doesn´t exist. Then maybe someone could help me how to identify the classname for level3 and level4 taking in consideration the cases when the ..read more

First of all, I know about the unique function available on MS 365/ MS office 2021. But my company wont upgrade to those versions. so I'm stuck with 2019. I need to Count Unique value & count only duplicate value of a excel sheet. I have explained it in attached excel sheet. So please help me if anyone can. Attached Images TEST COUNT.png (68.0 KB) Attached Files TEST COUNT.xlsx (32.4 KB ..read more

Hey everyone, Im trying to make a pivot table out of my sales data, when I enter the date in the rows field while making the table it says they cannot be grouped. I'm using a random date generator which is =RANDBETWEEN(DATE(2020,1,1),DATE(2023,12,31)), as I've got 26000 rows. Ive also tried to just enter the date itself in the format 01/02/2023 but its still not working. I've looked up online as well but as I'm using a random date generator there can't be any alphabets or anything in the rows which usually causes the problem. My end task is to build a dashboard but I cant get through the date ..read more

I use VBA code to draft and send mails. However its .Body function removes the default mail signature and then enters the body content. I've been using SendKeys method after this step to insert the signature again and it has been working too, however will prefer to have an easier option if possible ..read more

Is there a way in excel to find frequently used text/words in a column ..read more

Hi can anyone please help me remove the weekends in this file how is it done? using excel 365 thank you Attached Files BLANK TOTALS FINAL VERSION.xlsx (175.2 KB ..read more

Am trying to do some data manipulation, and I'm just not that good in Excel. The attached image (Excel) shows a (very) simplified version--A list that shows Applications by Role. What I need is a list displaying Roles by App (Excel2). The list is large enough that doing this manually really isn't practical. Any help would be greatly appreciated. Attached Images Excel.png (7.2 KB) Excel2.png (4.9 KB ..read more