Suoritettu

Query Excel Sheet - Excel Expert Needed

I have an excel sheet which contains orders with stock availability. You need to create a query which finds products with high not in stock volume and puts this information within the excel sheet.

See attached [url removed, login to view] for reference:

A - Query taken from 'Old' Worksheet

B - Option to select which lines to query (e.g. Line 4080 - 4117)

C - Finds all rows with 'Not in Stock' or 'Incompleted' in Column F

D - Finds the products highlighted red in Column E, regardless of size (e.g. AJ4-20(10) where 10 is the size) - When highlighted Red, it means the item is not stock.

This information queried should be put on a new worksheet within the Excel file. See [url removed, login to view]

Product - Which Product was found Not in Stock

Not in Stock - How many times found Not in Stock

Lines - Which rows on the 'Old' Worksheet is the product shown not in stock

The resulting information should order the products found Not in Stock the most at the top. (e.g. Products found not in stock 10 times should be higher then products found not in stock 8 times)

If you are confident you can create this for me please make your bid. If you can create it before you bid and show screenshots to show it in action, it is more likely I will select your bid as the winner immediately, price depending.

Thank you!

Taidot: Excel

Näytä lisää: top query, n query, me excel, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, how can i expert in excel, file excel expert, expert with excel, excel 0 to expert, new excel, how to be expert in excel, excel sheet expert, sheet, price excel, need a excel expert, line sheet, jpg to excel, Expert Excel, EXCEL SHEET , excel sheet an, excel expert, d sheet, create excel worksheet

Tietoa työnantajasta:
( 22 arvostelua ) New York, United States

Projektin tunnus: #516111

Myönnetty käyttäjälle:

svet63

VBA developer since 1997. Can do. Regards, Svet.

65 $ USD 1 päivässä
(57 arvostelua)
6.5

27 freelanceria on tarjonnut keskimäärin 60 $ tähän työhön

vserv

Hi, Please see your PM

30 $ USD 5 päivässä
(56 arvostelua)
5.8
agihcam

Please refer to PMB.

50 $ USD 1 päivässä
(39 arvostelua)
5.1
pyazlm

Better check PMB.

30 $ USD 1 päivässä
(30 arvostelua)
4.4
ranbir123

Pls check the PMB.

80 $ USD 0 päivässä
(12 arvostelua)
4.4
mahfuzmurshed

Please see PM.

30 $ USD 0 päivässä
(33 arvostelua)
4.0
nmppatel

I am a VBA expert, I have very good experience with EXCEL VBA macros. I have completed many projects on GAF in EXCEL skill. I will provide quick & professional service.

30 $ USD 1 päivässä
(9 arvostelua)
3.7
monica365

Hi, This can be achieved creating a macro in MS Excel. Thanks! Monica

30 $ USD 3 päivässä
(3 arvostelua)
2.7
skujuira

Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards

110 $ USD 3 päivässä
(2 arvostelua)
2.7
ruimaxwell

Hi Please read my PM Thanks

120 $ USD 2 päivässä
(2 arvostelua)
2.7
bkragul

Hi, Please check your PMB..

30 $ USD 0 päivässä
(8 arvostelua)
2.9
Abikris

Hi, Check your PMB please. Kris

30 $ USD 0 päivässä
(5 arvostelua)
2.5
codezero786

check your PMB

30 $ USD 0 päivässä
(3 arvostelua)
2.3
SSYES

Hi, Please can you check my Private Messages Thanks.

100 $ USD 1 päivässä
(1 arvostelu)
2.0
excelmodeler

Hi I have developed similar models while working as a financial anayst. I would like to develop it for you. Thanks Manoj

50 $ USD 2 päivässä
(1 arvostelu)
1.4
dimp01

giv me a chance...

60 $ USD 3 päivässä
(0 arvostelua)
0.0
ali3134021333

Please refer to the PM

80 $ USD 1 päivässä
(0 arvostelua)
0.0
agust8

Please check my work in PM.

50 $ USD 0 päivässä
(0 arvostelua)
1.2
blitzer526

Please see PMB. Thank You Very much.

30 $ USD 3 päivässä
(0 arvostelua)
0.0
rurirum

Rurium East africa is Up coming Bpo, Based in Nairobi Kenya. We are keen in providing good service and we hope you will be in position of giving us your present and upcoming jobs

200 $ USD 4 päivässä
(0 arvostelua)
0.0
milagrosmorre

show me the instruction and the file

60 $ USD 1 päivässä
(0 arvostelua)
0.0