excel365

  1. E

    Finding the dates a person has visited the place , in a table

    Hello , im kind of stuck , I want to find the dates or the numbers of visits of a person In sheet 1 "B2" I can put the name of the person registered , and then in "F3" and downwards it shows me the dates the person was visited , or the number of visits (lets say visit 1 , 2, or 3) In sheet 2 ...
  2. I

    Enhancing Search Functionality in Excel Database

    My name is IMaadh, I’ve created an Excel sheet that functions as a searchable database. Currently, I can search for any single entry within the table, but I want to enhance it to search for details in two cells simultaneously. Example: Table headings: Staff Number, Username, Location...
  3. W

    Combining Filter function with Indirect/Concatenate to look up from another worksheet

    Hi, I've created a formula that works fine if it is within the sheet where the data originates, if is filtering the routes our vans will be taking and excludes any blank routes (if a van is not scheduled out that day). But I want to have the summary in another sheet dynamically changing based on...
  4. P

    Insert a image as footer on multiple sheets based on a reference from Sheet1?

    I have a workbook with scripts/modules. And running through many of them with the logic of: For Each sh In Worksheets If sh.Name <> ..... etc ActiveSheet.PageSetup.CenterFooter = "& "&N" or whatever i need on each sheet. I am excluding Sheet1 from the 'loop'. But on Sheet1 i have a image...
  5. I

    Conditional formatting: If the total of two cells is lower then another cell

    Hello, I would be really grateful if someone could answer the following If the TOTAL of two cells is less then the value you of another cell then post cells red, for example; if A3+A4 is less than C5 turn cells red thank you in advance
  6. J

    Spilled array formula to match column for minimum of each row in a 2D table

    I have a 2D table of timeseries data. I am able to use the following equation in column B: "=BYROW(Value_Array,LAMBDA(x,MIN(x)))" to get the minimum value for each row that results in an array output. In column C the following does not work "=BYROW(Value_Array,LAMBDA(x,MATCH(B6#,x,0)))" to find...
  7. mehidy1437

    Search value in VBA

    Hello Guys I'm facing an issue with searching value in excel in VBA. When I search a value, if the value only exist in a1 then below code give me the resul a1. But if same value exist in a1 & in any other cells like in a2 or b2, it gives me the result b2 or a2 i/o a1. Why is this happening...
  8. R

    Month Name from date in number format

    Good afternoon, I am in need of a formula that will identify the month name in one column from the month number is another column. To be specific, I need the "MONTH" column to show the abbreviated month name using the number in the "MONTH #" column. Any help would be greatly appreciated...
  9. D

    Excel365 Cascading Data Validation between multiple worksheets (within same workbook) - no VBA

    I'm developing a workbook for Risk Analysis. Currently we have a single list/array with several thousand lines. We want to make it more managable, by splitting it according the different departments. But the Risk Theme and specific Risks are identical for all departments. I've created a...
  10. D

    calculate SLA or TAT by excluding non-business hours

    Hi All I am hoping that someone can help. I have been reading the post (Calculate only working hours between two dates excluding weekends) as it was on the right lines for what I needed but I couldn't find the specifics to help me. I have a similar problem with the exception that I work in a...
  11. mehidy1437

    Restrict spill result from if formula in 365

    hi, I'm getting spill results on multiple columns from the below formula. =IF(R2:V2>0,"",O2) but I don't want spill results, I want results in a single column. This gave me a #value error. =IF(@R2:V2>0,"",O2) How can I sort it out?
  12. L

    Is this possible? VLOOKUP, CONCAT, TEXTJOIN, LEFT, help!

    Ok, I don't think what I'm trying to do is unique, but I certainly can't seem to work it out or find any examples, or even failing that, think of a better way. Sheet One contains cells with Action Groups. These cells might have one action group per cell, or multiple action groups per cell, such...
  13. K

    Splitting activity duration by hour intervals

    Hi, i hope someone can help me. I try something similar as already described here: Splitting activity duration by half an hour intervals I too have a long list of activities and their start and end times. What I need is to split the duration of each activity into hourly intervals. At "Normal"...
  14. F

    Use VBA to select a local (closed) workbook and import some of its data into a selected range

    Hi all, Very new to VBA and trying to learn as I use it. I have searched for this extensively and found a few instances that seem get close to what I need to do, but I still do not know enough to be able to adapt them to my needs. Basically, what I would need is a macro to import data from one...
  15. V

    VBA code works in Excel 2010 but not in Office 365

    I have this vba code that I was running previously in Excel 2010 on windows 7. In a nutshell the code is creating a new worksheet and is copy and pasting the recordset into the new worksheet. Then the code will do a lookup and insert new data into that same worksheet. Recently, the business...

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