solution

I have a list of items ordered by a value representing years left and an value attached for each item. I need to determine if there is an easy method of choosing a range with an average age (say 15 Years in my example) and seeing what the average item value is for that group. At the moment I am...

Afternoon Ppl, need some help here, how do i convert eg 25122019 (ddmmyyyy) or 251219 (ddmmyy) to show its Qtr4 19 ? Any solution to this ? Much thanks.

I have a workbook that will have a dozen or so sheets that will vary in name on a regular basis. I want to be able to copy all sheets after the fourth sheet into a new .xlsx workbook. I have looked for a solution, but all I find is Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select...

I'm looking for a formula in cell D1 and down, that will add 1 or 2 "0" in front of the ( digit or number ) that when I "concatenate" them together from cell A1 with B1 see picture or is there another solution ? Thank you

Hi Friends, I’m not sure if this is possible using standard Pivots or Functions, but if it is then I know someone on here will have the solution. Basically I would like Excel to return rows of Data based on a single Criteria, but with the difficulty of being across multiple Worksheets (or...

Hi all, I have been reading a lot of content here over the years and would like to congratulate the helpful community for the fantastically helpful work all of you have provided here. How, I am posting here for the first time, as I can't find a solution to my problem using the search function...

Hi, I need to send each person his excel attachment , with a template email what would be the solution for 100 more people

Hi all... i have a fairly simple problem with what i think is a pretty hard solution (at least to me) so i have a sales comission report and need to pull agent totals to another excel file. Seems pretty straight forward.... Except this report creates a new row per sale... so the totals row...

Hi Experts, Can anyone give already made the solution related topic to my subject.. Im getting an error on save as line code

hi, HR0810919 I only want to extraxct the 'red' text into another cell (char5&6) and prefix with Fl.. Tried, left, right & mid..but no luck:banghead: Does any have the solution for me? MTIA Trevor3007

Hi, I'm looking for a solution to the following issue please. I am importing data into excel from a web application where some of the data is in "free text" format. I am trying to extract the first group of numeric values from a string, so for example cell in cell A1 if the value is something...

Hey All, I'm trying to track what games friends have vs what games I have, etc, so I decided to use Excel and make a list, etc. Then when the weekend comes I can just look who is around and decide on a game we are playing. When I do a drop down list to allocate the game names to the person...

I feel this should be a very easy solution, but I am finding myself struggling. For p = 70 To 73 If tpgo = "<" Then pdd = format(ws_sbase.Cells(p, 2), "h:mm am/pm") If pdd >...

cfn = ws_vh.range("B23") cfn = "May-24 (Fri) schedule_1.xlsx" I am looking for a vba solution to replace the "_1" with "_2" in this string.

Hi, I have not had a viable solution to share a workbook. Does anyone know how? Thanks

Hi all! I've been searching all over for a solution and I'm stuck, so I'm turning to the experts. I have a large spreadsheet with data scattered across multiple rows. Example '2" yellow webbing' might be in cell C4 or it could be in T4 or anywhere in between. I want to search cells between...

Hello, I have the attached image (left) of more than 45k data points and I want to delete all the points within a range from the trend line to have it like the one on the right side (only the points between the two red lines, deleting all other points that fall out). I can't think of a...

Hi Folks, Just a quickie (I think/hope)... :roll: I had a formula in a spreadsheet cell: =TRUNC(MAX(((MAX(E5-5,(E8-4)))/10),1)) that I needed to move into code, i.e.: Sheet1.Range("J18") = TRUNC(Max(((Max(E5 - 5, (E8 - 4))) / 10), 1)) The VBE/Compiler doesn't like it in this form. After...

Hi guys, i know there will be a simple solution to this. How do I get for example 90.7% to show as .907. Many thanks, Jim

I have run into a pretty significant loss and after an exhaustive Google sesrch I wasn't able to find a solution to address my issue. I have a userform for in workbook1. A click on one of it's objects is to facilitate the launching of a second userform in a second workbook (wb_rd). This second...