excel 365

  1. A

    How to convert quarterly data to monthly data if I only have quarterly?

    Hi, I just started a new job and my manager has asked me to look into an existing spreadsheet we have. It contains quarterly data from the company's call centre, compiled for a previous project that looked into assessing how call agents performed and achieved KPIs on a quarterly basis. I've...
  2. J

    Standard Deviation between Two Dates

    Hello all! I am working on a very large spreadsheet and need to calculate the mean and standard deviation for each month of 2021. I've figured out the formula for the mean but the standard deviation isn't giving me the correct information. Cell References $D$1 is the year (2021) $D$2 is the...
  3. X

    Array that can pull data from different ranges

    {=SUM(INDIRECT("'sheet1'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$2,INDIRECT("'sheet1'!A1:"&SUBSTITUTE(ADDRESS(1,O1+16,4),"1","")&ROWS($M$1:$M$1)),0),4),"1","")&XMATCH($B3,INDIRECT("'sheet1'!$m$1:$m"&M1),0)):INDIRECT("'sheet1'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$2,INDIRECT("'sheet1'!A1:"&SUBSTITUTE(ADDRESS(1...
  4. Q

    Fill column with default values

    Dear best regards I am trying to get the values that are located in column B, to be reproduced in column C in the same order as they appear. The problem is that I have entered some formulas that do not allow me to obtain the values I require, and instead they always reproduce the same one...
  5. N

    Auto populate from 6 different sheets - Excel 365 and Google Sheets

    Hi, me again as you guys are really helpful. My next question that I can't seem to figure out is there a way to auto populate a sheet every time you add a new entry to a different sheet. This is the scenario: 5 sheets that I enter information into based on their filters. These sheets will have...
  6. J

    Attempting to Search one cells number values against an numbered ID list

    For starters this cannot be in VBA the intended users are not familiar enough with VBA to maintain the document. That being said im 90% of the way there. I have one cell with 2 or 3 number values between 1 and 35 and another cell returning all the values that are inside that cell. My only...
  7. Q

    Convert numbers to letters

    Dear all, best regards I am trying to convert numbers to letters (in Spanish) with the help of some formulas, I have used the range of numbers between 1 and 999. The formula I am using seems to work but not quite right, since it gives results for any number greater than 100, but when I use a...
  8. Q

    Sum a range of data considering a range of criteria

    Dear beast regards I am working with some figures on the number of people in a country, classified according to sex. I want to carry out sums taking into account specific age groups, for example Men between 2 and 10 years old (Men_2 - Men 10)...
  9. T

    VBA: sumifs data and calculate score base on multiple criteria in cell value

    it is a bit complicated. excuse me! I have raw_report which contain teacher name and daily attendance for student on each subject. In template, i wanna make a button so that my colleague can click and generate the score of their student base on daily attendance. First, it need to look "Team...
  10. S

    Excel vba loop to find records matching multiple search criteria and multiple sheets

    Hi @all, I would like to implement the following function in VBA as a procedure. =INDEX(Zones!$G$3:$S$273;MATCH($A3;Zones!$C$3:$C$272);MATCH($B3;Zones!$G$2:$S$2)) I have two sheets ("Data" and Zones"). I search in the sheet Zones for zone numbers, to be able to determine later also the...
  11. Q

    Get the color of a cell from its hexadecimal value

    ABCDEFGH1ColorHexadecimalColor CodeRGBRGBName Color2#0048BAAbsolute Zero3#B0BF1AAcid green4#7CB9E8Aero5#C0E8D5Aero blue6#B284BEAfrican violet7#72A0C1Air superiority blue8#EDEAE0Alabaster9#F0F8FFAlice blue10#C46210Alloy orange11#EFDECDAlmond12#E52B50Amaranth13#9F2B68Amaranth...
  12. W

    Link data from file that's name changes daily.

    Hello, I have a sheet in a file which I would like to update automatically with changes. the problem is the file name changes everyday in the format of "AAAA01232022" to "AAAA01242022" so the change is in "mmddyyyy" format and progressing by one each day. Occasionally there are days the file...
  13. Q

    Error in VBA Sub Colors() lines of code

    Dear all, have a very happy beginning of the year. I am carrying out a code in VBA, I am novice in these subjects, the idea that I am trying to develop in the worksheet 1 is to show the different options of colors that Excel has available (or at least of which until the moment I have...
  14. Q

    Extract the last characters in a cell.

    Dear cordial greetings I am learning the basics of Excel's VBA language, and I have come across the issue related to the default color range. Investigating in different sources I have found a code that allows to obtain the values for the RGB primary color palette, presenting them all together...
  15. Q

    Search for data in a matrix from several parameters.

    Dear all, have a nice day. I appreciate any information you can give me about the following question. I am performing a search process that allows me to find, within a set of students [A2:A9], who obtained the highest grade [B2:I9], for a set of subjects [B1:I1]. I found a solution, but it...
  16. G

    FILTER Function

    Ok, so this is a follow-up to a previous thread which I thought I had solved and turns out I was just really tired and not paying attention to what I was doing. Apologies for re-introducing the question. I have 4 tabs worth of information: 1) Site information (Named table: T_Branches)...
  17. M

    Links only updated when [check status] is clicked

    Hi, I have one destination workbook open on PC#1 (Windows 10) The workbook has links to two source workbooks open on two networked (wifi) laptops (Windows 10) PC#2 and PC#3. I'm using the current version of Excel 365 (on all three computers). For the cells of the destination workbook to be...
  18. Q

    Alternatives for searching data from parameters

    Dear all, have a very nice day I apologize for the lengthy statement, but I want the problem to be well formulated to avoid confusion. In the 'Data' worksheet, you will find information that compiles the weather conditions recorded daily for any given city from January 1, 1999 to December 31...
  19. Q

    Conditional data validation drop-down lists

    Cordial greetings I have two concerns and they are as follows. The first one is, in column A are registered 6 States with their respective cities, the name of each State is in capital letters, now, I need to extract in a separate column (can be for example column L) only the names...
  20. Q

    Sum values from arguments registered in cells

    Good day I need some help. I am trying to calculate the cumulative grades obtained by each of the students (5), in each of the subjects taken (9). For example if I select student Abby (D17) from a drop down list and I want to know her cumulative grade recorded in chemistry (D18), for cell D20 I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top