Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to =a set of numbers to a given week day.ie 6031 = Wed ect
I need to assign a week date to a given set of warehouse numbers.. As example
6031 = Wednesday, 7033 = Thursday ect... I have 39 #'s to apply the weekly format to. Wisdom... Thank you LO |
#2
|
|||
|
|||
I need to =a set of numbers to a given week day.ie 6031 = Wed ect
On Tue, 25 Oct 2005 13:38:12 -0700, Budman
wrote: I need to assign a week date to a given set of warehouse numbers.. As example 6031 = Wednesday, 7033 = Thursday ect... I have 39 #'s to apply the weekly format to. Wisdom... Thank you LO Is there any system as to how these numbers are assigned? What is the "weekly format"? With the limited information you provide, I can only suggest a lookup table. Look at HELP for VLOOKUP. --ron |
#3
|
|||
|
|||
I need to =a set of numbers to a given week day.ie 6031 = Wed ect
From what you've said so far, I would use the VLOOKUP function and make a
table of your 39 numbers down a column somewhere out of the way and put the Weekdays in the next column to the right, then use something like =VLOOKUP(A1,YourTableRange,2,false) Vaya con Dios, Chuck, CABGx3 "Budman" wrote in message ... I need to assign a week date to a given set of warehouse numbers.. As example 6031 = Wednesday, 7033 = Thursday ect... I have 39 #'s to apply the weekly format to. Wisdom... Thank you LO |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
Week Numbers | Excel Discussion (Misc queries) |