apple

Good day. Need to know price of apple in 120203... what excel formula shall i use??? i have large database with different product code as well as market code!!! <tbody> Product Code Product name price market code 001 apple 2.00 120203 001 apple 2.00 120203 001 apple 3.00 120203 001...

Hello guys, Need your help as i need to know listed (repeated price) price for apple sold in 120203 :warning: which excel formula shall i use? i have large database with different product and market code... <tbody> Product Code Product name price market code 001 apple 2.00 120203 001...

I have column <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera...

I'm working on constantly changing retail price for a list of items, and I want to pull the most recent price based on date. For a simple example, if column A is Item # (A1), column B is Price (B1), & column C is Date (C1), let's say one unique item is Apple, and there are 3 entries for Apple...

Hello, i have a little issue with a loop. it should loop through until it find a cell with a value, let say apple and move through the rest of the loop. But when it gets to the value apple it's not doing anything and go's to the end. For w = 4 To lr - 1 If...

Hi, So I have a case where I need to return all results in a column where 2 criteria are met into one cell. My table looks something like this +-----------+------+-------+ | Job | Type | Name | +-----------+------+-------+ | Tree | AA | Bob | | Apple | FF | John | |...

Hi I would like to seek some advice on how I can do the following. I have a macro(I use a do while loop to check and insert the extra row) that sorts out data in a certain format by inserting a line(row) in between 2 rows effectively separating the data set. After running my macro, I am...

Hi Hope someone can help me please I have a spreadsheet full of data that is not totalled. I cant think of a way to do it. In total I need about 1500 totals so it will take a long time to do manually. See example below Each mini table of data has multiple lines (rows between them)...

Hi, thought this would be best explained with an image. Is it possible to use the "key" as conditional formatting? So for example any cell in column A with "Apple" will match its formatting in cell D4

Hi all, Please help! I need a macro that does the following: User will input the information in the table below. User will then click a button tied to the macro. The macro will return the filled out table in a newly created sheet. For the table created by the macro, the cells will need to...

Dear All, Need some help on retrieve unique values into column E. Please refer below for samples. i have tried vlookup and hlookup but can't work :( <tbody> columnA columnB columnC columnD columnE reference apple not not not apple watermelon not orange not not orange banana not not...

Please can someone help to come up with formula that would count cells with text if condition is "time"? The "count" column is where the formula that would count the number of fruits once the "start and end" time were met. Example: the first count in "count" column is 2 - this is because "apple...

I have an Apple Mac Computer with Excel installed on it. When I scroll down while in a spreadsheet, I am unable to easily stop the scrolling by using the mouse and/or touch pad. My question is: Is there a fix or a process that I can implement in order to better control the continual scrolling?

I have a list of names and account in different columns. i need to transpose all the account names to one name as mentioned in the below. each name has different number of accounts to it. <colgroup><col><col span="8"></colgroup><tbody> Name Account Apple atlspmgr2 atlspmgr2...

Hello, I have multiple excel sheets from each sales person which has the below data. Each sheet is broken down into 2 different sections one for sales which has the sales info and the 2nd for leads info. I have 1 macro which combines multiple excel sheets into 1 excel sheet but it pastes in...

I am trying to create a macro to sort and replace text and have an example below. 1) First I want to sort everything with column b from lowest to highest and that would sort the other columns with it, so each row keeps the same info 2) Next, replace the text in column D with a new word - for...

Hi all, Please help! I need a macro that does the following: User will input the information in the table below. User will then click a button tied to the macro. The macro will return the filled out table in a newly created sheet. For the table created by the macro, the cells will need to...

Hello, I am trying to search a large list for the number of occurrences of a word located anywhere within a string, but can't figure out how to do so with countif and find. The list would look something like this but longer: (Searching for the number of occurrences of "apple") <tbody> A B...

Hi all, I'm mediocre at best with VBA so need quite a lot of help and may be asking questions to understand better. I need a macro that does the following: User will input the information in the table below. User will input a category (Fruit) and an identifying label (Color). User will then...