Hi ,
I am trying to set up excel to covert my numbers into a code 39 bar code. I already have the codes but they are showing in excel as a number. Any idea how to convert back
Column E is the number.
look forward to hearing from you.
Arthur
Hi ,
I am looking for help with the following.
=vlookup(MastersheetF4,VDQ Weds D3:D60 - if true returning = VDQ Weds column C3 )
Basically - If 914 is on VDQ weds D3:D60 return VDQ weds Column C3
Any advice would be amazing
Hi Narayan ,
Rule 1 - look =VLOOKUP(MASTER!D4,’VDQ Monday’!A2:A166,1,0) this returns payroll number 914
Rule 2 - =VLOOKUP(C3,’VDQ Monday’!D2:D166,1,0) this returns Name "RKD Sprout Peeler"
RULE 3 - If rule 1 is true (payroll 914) and rule 2 is true ( Name "RKD Sprout Peeler") please return the...
Hi Everyone ,
please help with the formula. New to this game
=VLOOKUP(MASTER!D4,’VDQ Monday’!A2:A166,1,0) (914)
=VLOOKUP(C3,’VDQ Monday’!D2:D166,1,0) (RKD Sprout Peeler)
I need to combine the two arguments
Help
Hi Narayank ,
1 - VDQ Saturday to VDQ Friday will have the same fields always. We will be exporting the data on these sheets daily.
2 - The data imported onto VDQ sheets need to picked up on the Saturday to Friday (colour) tabs
3 - Using the MASTER(payroll numbers) as first unique identifier
4...
Hi everyone (awesome site),
I am looking for some assistance on the excel sheet attached?
Example
we are trying to be able to set the colour tabs (Monday etc) to accept a file dropped into VDQ Monday and this will populate the Monday(coloured tab) based on the following;
If "master sheet D4"...
Hi everyone ,
I am looking for some advice on the following:
Performance management is a tool we have to use and I have set an excel spread sheet using conditional formatting (changes colour). But I now need to know the number times between 80% and 90%. I have used countif to find the number...
Hi Guys & Gals ,
Struggling a bit to formulate a string to pick up the following information ;
Summary ( Final destination)
NAMECONTRACTIDDRYSDALE ASSIGNGVAP ASSIGNHAGGERSTONSETON
Abida, Mustapha0
Sheet 2
NAMEcontract
Abida, Mustapha1
Sheet 3
NAMEID
Abida, Mustapha
1
Problem I have is the...
Hi , help.
I looking for help with the following problem. Attached is copy of a document we use to record output in production area.
Question.
Howe do I get the following to show the minimum amount?
=SUMIF('Line data'!C5:C133,'Line Data Weekly'!A6,'Line data'!I5:I133) this shows the total...
Hi
I am new to this group but have had help before and now I asking again.
The issue I have is as follows -
Rolling average of pay -
Data Range - B4 - B16 on going up to B56 - people weekly salary.
A2 - A567 - Individuals Names.
I need formula which shows 12 week average rolling each week...