...with populating data in columns 'E' and 'F', (Platform and Query). - He or she would randomly select a ‘platform’ from 'list of platforms' (from column D) and adding it to cells in Column E. In addition, the candidate will make queries (in Column F) based on the platform in column 'E'. (The test user has to insert the name of the platf...
Hello, Please see the attached xls file. It should autoincrement cells in a column, whenever a value is entered in other columns. And whenever a cell is selected (left mouse click) and enter pressed it should autoincrement the selected cell. I need this to work in wps office ... spredsheet. Thank you,
Hi, I want you to remove this error from the project. Resolve it using TeamViewer. I will give access to my pc.
...semaphore at all! - Design the shared buffer to have 10 slots: o Use an integer array to hold the contents of the buffer o Use a counter variable to hold the number of occupied cells o Use a variable to keep track of the next location for the producer to insert a value o Use a variable to keep track of the next location for the consumer to remove a value
I have a spreadsheet from Google AdWords which has city names for cities it recognizes and then postcodes for the rest. I have another spreadsheet which has the city names for those postcodes. I need those names merged into the Google spreadsheet.
...then examine this to give some recommendations and then using a drop down sheet we then add some comments. The colours on the results page are too bright - there are some cells that aren't linked properly (just the paddock name and the property name (customer name) in the header (set at Dorrington at the moment), when i select the from the dropdown
...absolute differences (in whole rounded hundreds) in the estimates of 10,000 individuals or more between the two datasets. If the earlier estimates are larger than 10,000, the cells should indicate a negative value. Provide a screenshot of your tested code showing successful execution. Explain how you prepared the data and how the datasets were imported
I need a very simple export/save as button added to my excel file. 1.) The button needs to have a conditional format. When 2 numbers (cells S1 & S2 = each other the button is active, when said numbers do not equal each other button is deactivated. Button location is cell R4 (Where it says EXPORT). 2.) When this button is active and pressed it exports
...delivery according to zones 2) Schedule servicing of taps (we're in the beer business) according to zones 3) For service and delivery employees to click check when done The cells should include sorting according to 1) Month 2) Week 3) Client Company 4) Employee 5) Work type - Kit delivery, Regular servicing of taps, Draft set up, Draft pick up
Cut and merge 3 videos from our suppliers into one video. Download the material from youtube yourself and cut them accordingly. Yes, we have permission to do so. Sound must also be merged and cut so it flows naturally. Redtronic, Get Redtronic logo from this video: [url removed, login to view] Cut video and use content from
...ferieplan fields B4) see if “x” on Thursday 'T' field E6 If there is a “x” then open the sheet “17” and find employee Karina Line nr. 5 and 6 Paste “Ferie” inn cells H5 and H6 With yellow background red text in size 36 Information: 'Employee Name Stands in sheets ferieplan Row a6: A18 It must do it f...
Vlookup of email addesses to identify...are any duplicates Assign a column with only the emails that does not have any duplicate matches in a format that can be copied ( no formula, only text format and no empty cells between the entries) The emails that did not have a match in the lookup field to be added in the lookup field for next run of the macro
... We're currently creating videos for daily innovations that we find interesting. Examples: glass that heals itself, edible electronics, 3d printers that print with live cells. I need someone who can take a list of captions and find one 7-9 second clip or image for each caption. Here are the quality guidelines: 1. We want the image/ video that
We need a macro in excel which deletes an entire row, if two cells in a row show an outlier. Our problem is the following: in large data sets, it might be difficult to find outliers. Therefore, we need a macro. An outlier is defined by the difference between 2 data points. Therefore, the macro should be able to delete a row, if the difference between
...for a self assessment by users. Rules and conditional formatting will produce automated scores and matrix chart. See attached spreadsheet. REQUIREMENTS: 1. Column H. The cells in Column H, must have a red/amber or green colour for each row item, based on the rules given in the sample matrix 2. Executive summary 5 x 5 matrix. Each row item short code
i need help in formula which will let user insert a row in a protected sheet. 1) the cells in yellow I want it locked 2)the problem when I insert a new row below locked row, it becomes locked and i don't want that 3) i want new row to be included in equation i want to attach file plz