accepted

Hi Not sure why My1 is not accepted as macro name. I opened a new excel file then went to developer--> record macro--> then typed my1 as a name for the macro but got error message. Thank you very much.

Hi My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted yyyy-m-dd as a date and why accepted sept 14, 2019 as a date and changed to 14-sept-2019. but why did not change it to 14-09-2019 (why 09...

In columns AL and AM a date can be inserted, and in Column AN states "Accepted" or "Rejected" What I need is a formula that counts the numbers of Accepted, but then refers to the dates in columns AL or AM (Providing AN is accepted) - If a date is in AM I need it to ignore the date in Column AL...

Found a some cool search code. I replicated it in my test workbook, worked fine, which means the "LiftFillRange" accepted the name for the code. =Search!$D$2:INDEX(Search!$D$2:$D$16,COUNTIF(Search!$D$2:$D$16,"?*")) In the name manger its called "search" So I duplicated it in my project and...

<tbody> SSD PSD HSD K FORMULA 73.6 134 41 118 IF(OR(AND(K>=73.6(SSD),K>=41(HSD)),AND(K>=134(PSD),"1 CONDITION=ACCEPTED THEN TAKE "K"VALUE IS ACCEPTED,2-CONDITION IF NOT ACCEPTED CHANGE THE FORMULA TO K>=73.6(SSD) Criteria must be as per the formula </tbody> Can i get hep with this formula

I have a spreadsheet that I would like people to be able to only enter a time value into. If they enter time as 01:35 this is accepted. If they enter 1.5 it is refused as not in a time format. However if they enter 0.6 it will be accepted and show a time value of 14:24. Surely this decimal value...

Hi I want to learn when I use := or () or "argument" when I use a function. I tried to write workbooks(1). protect in 3 ways and they all works! which got me more confused. Why the 3 of them accepted. Workbooks(1).Protect "123" Workbooks(1).Protect ("123") Workbooks(1).Protect password...

Hi, I have group of tickets that are in different statuses. For example: 2018-06-21T13:02:19.639 -> Accepted For me I am interested only in the Accepted and Invoiced data and have it linked to SKU. I want to have those cells with the accepted or invoiced information, matched by SKU. I have...

Not sure how or if this can be done. Workload pull has in column "A" contract number, (hundreds of contract numbers), column "B" has the line item for each contract number, column "C" purchase qty, column "D" shipped qty, column "E" accepted qty. Need a formulas in column "F" to identify...

Friends, I need a little help, if you can please do. In below link, I have attached my sheet. In Column E, i have given a drop down list from where any value can be pasted. but whenever I copy some value from other sheet and paste, it is also accepting values other than listed in drop down...

Hi I have tried to enter same date into 2 different computers. I noticed one computer accepted 1/1/2017 as a date but the second computer did not accept it and the date stayed in the left hand side of the cell. Why is that? Why one computer accepted 1\1\2017 and others not.

Hi I just tried to enter different date to learn how to do that. so excel accepted these date 1/1/2017 1/1/2018 1/1/3000 (year 3000) 1/1/4000 (year 4000) 1/1/9999 but then excel did not accept the following as date 1/1/10000 why is that? Thanks

I have a spreadsheet with multiple columns, a "submitted date" and a "predicted date" (which is 7 days after submitted date) also 3 status columns, "accepted", "accepted as noted" and "not accepted". I am trying to find a formula that will say if one of the 3 columns is not filled in by the...