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 [login to view URL] 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 [login to view URL]

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 %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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