1. S

    VB Maro for Excel

    Hi I am Preethi, Please help me in VB Script I have large excel file which I have to mail the particular line items to customers. (for example) <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Code...
  2. H

    Formula to fill dates but leave out those that don't meet specific criteria

    I've received some great help with a formula for date series' that allows me to fill this formula in date sequence however, omitting Bank Holiday Mondays and where a BH Monday occurs, it simply skips that Monday date from the series and just goes straight on to the Tuesday. I'm then able to use...
  3. A

    Trying to redeem myself from being an idiot!

    I apologize, I really got reamed for my last post (and justifiably so) and I will try to make it right this time as not to waste your time again. I would like to get the number of days between the last two dates in the date column that has the task columns checked (columns C, D, E & etc.)...
  4. L

    mail merge change the format of the date

    Hi I am not sure if this excel or word issue. I have a column in excel which has dates formatted as below. When I mail merge to word, I loss the format and the date will convert to something like that 30/09/20, instead of the format below. Why is that. Thank you so much...
  5. D

    need help with formula to set up a warning after 2 work days

    Please advise. I am pretty green to formulas. I have created a spread sheet for query letters which are considered late after 48 hours. Monday through Fridays are only time counted (if letter sent Friday noon, it would be late Tuesday at 1:00 P.M). my J column is running current date, my E...
  6. D

    get the 12th date

    not sure if this is possible, but I'm trying to get the 12th day ..but if the 12th day falls on a weekend , I want the tuesday following e.g., this month (July)...July 12th is fine because it falls on a Friday but, for May....the 12th was on a Sunday, so I want the formula to pick up May 14...
  7. N


    Hello, I am wondering how to enter the month and date on a new spread sheet that excludes sat and sun but adds tues and thur twice on the spead sheet. Can someone assst? It should look like this <colgroup><col></colgroup><tbody> Monday, June 3, 2019 Tuesday, June 4, 2019 Tuesday, June 4...
  8. F

    How to use SUM function to get specific value

    Hi Excel Gurus, Is there any option to add the columns to get particular value. Lets say for example as below: 500 500 500 500 150 150 Can we able to get only 300 as result by adding this column.
  9. F

    How to Reconcile two values splitted in multiple rows in same column

    Hi Excel Gurus, How to Reconcile two values splitted in multiple rows in same column In the below example you may see, for each day, we have same amount in two columns but these amount are splitted in third column, how can we match these. Any suggestions. Example: <colgroup><col><col...
  10. S

    How to put auto page break while printing

    <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> 1000 3/25/2019 Monday 08:14:53 16:43:05 08:28:12 08:28:12 1000 3/26/2019 Tuesday 08:16:12 17:04:13 08:48:01 08:48:01 1000 3/27/2019 Wednesday 08:25:33 -- -- -- 1012 3/2/2019 Saturday...
  11. K

    schedule generator 2 game per day (darts)

    hello im looking for a fixture creator for playing on the season 4 to 5 time each teams and we are playing against 2 teams each tuesday the number of team can also change from 12 to 14 can anyone help me ? Regards
  12. I

    Help make this formula more elegant

    Hi I've got this formula which works correctly but is a bit long winded and has a few nested IF statements; =IF(G7="eombh",INDEX(E2:E22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),IF(G7="eom",INDEX(D2:D22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),(INDEX(C2:C22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0))))) G2=...
  13. P

    Create a Dynamically Generated List Based on Criteria

    I've exhausted the googlez and yet to find exactly what I'm looking for. I have two worksheets. Sheet two is a drop in report from another source. Sheet one aims to provide a simple way for a user to query data on sheet two. Below is a watered down example of what I'm looking for. This...
  14. D

    Help with VBA

    Hello, I am making a macro which would create a "Result" sheet based on the "Input" sheet. In the "Input" sheet there is data containing columns Employee#, First Name, Monday am, Monday pm, Tuesday am, Tuesday pm, Wednesday am, Wednesday pm, Thursday am, Thursday pm, Friday am and Friday pm...
  15. P

    Excel formula to ifentify if a date is a Tuesday or a Thursday

    Hi guys in my spreadsheet I have site visit days, I need create a formula that goes as follows: =if(and(A1=“site”,or(B1=“Task1”,B1=“Task2”),if(C1(column with the dates in custom format “dddd, dd-mmm-yyyy”)=(need the formula to identify if the date is a Tuesday or a Thursday),0.5,1,)””))...
  16. E

    Count and text other row

    I want to know when there is a value in the cell, the number of times the value is in a different row and the text that says it. In the table when there is a value in cell B, I want the number of times it occurs cell A. So Monday 2 times, Tuesday 1 times and so on Is this possible...
  17. Trevor3007

    retain & add

    good day, I have a workbook with several worksheets, however there is a need to keep a record of repeated requests. For example. on 25/9/18 I request ID2663 to be re done, but if I do not get a response from the applicable 3rd party and have to request again. This is what I would like to see...
  18. xeven_

    Match Dates and values

    Using excel 2016 I have dates in columns A and C and values in columns B and D. The datesand their corresponding values are not matched but I only want to compare the values in B and D with their correspoding dates. Is there a formula I can put in the adjacent columns to match the dates with one...
  19. I

    Countif ignoring blanks weird table

    <tbody> A B C D E F G H I J K L M N F 1 Name Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday 2 John 8 AM 8 AM 8 AM 8 AM 8 AM OFF OFF OFF OFF 8 AM 8 AM 8 AM 8 AM 8 AM 3 David 8 AM 8 AM 8 AM OFF OFF 8 AM 8 AM 8 AM 8 AM 8 AM 8...
  20. R

    IF AND OR - Statements

    I've got my statement wrong or I'm trying to write this incorrectly. I have two drop down lists. M5 has 4 statements - Saturday, Sunday, Monday, Tuesday M6 has 3 conditions - Open, Lunch, Closed I am trying write an IF statement. Saturday & Sunday have the same answer for Open & Lunch =...

Some videos you may like

This Week's Hot Topics