Hi Guys,
I am using Excel 2016. Its been awhile since I posted would appreciate some help on the following problem. :(
I have the following list :
<tbody>
Fruit
Price
Apple
5.00
Watermelon
6.00
Mango
4.50
</tbody>
<tbody>
Fruit
Price
Watermelone 5KG
Banana 300G
Red Apple...
Hello! I'm having issues getting the correct formula to search a range and COUNTIF any part of a cell's text appears anywhere in the range.
Using A as the search criteria and C as the range, I would expect the column B results below, but, in B2/B3 it's returning 0 no matter what formula I...
<tbody>
Current
Desired Result
A
B
1
Apple
Apple
2
Apple
Banana
3
Mango
Mango
4
Mango
Peach
5
Mango
6
Peach
7
Banana
8
Banana
</tbody>
I need the value only listed once (preferably in Alpha Order) from a data set column that lists that value...
Sorry for the vague description but not sure how best to describe this. Here is the situation below. I want column C to be a formula. Out of all of the occurrences of Oranges in column B, if any of them have a value of 5 or above in column A, then I want it to return a Y in column C for all...
Hi,
coming back after a long time:) coz i need your help very badly.
I have 2 columns like below, I simply need to to transpose these data into columns in a new sheet
List 1 List 2
Apple Boomerang
Apple Offerings
Apple Industrial Equipment
Apple Chemicals & Natural Resources
Apple Consumer...
Dear Excel community,
Currently I have a column that looks like this,
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
Mango
Apple
Orange
Pear
</tbody>
Is there a VBA that can help populate the blank cells...
Hello all
Could anyone help count my below issue?
Thank you very much
<tbody>
A
B
1
0-100
0
2
100-500
2
3
500-1000
2
</tbody>
I would like to count column A that meet criteria with above table
<tbody>
A
B
C
D
1
Apple
100
2
Orange
300
3
Mango
500
4
Apple
1000
5...
Hi Guys,
Using Windows 7 & Excel 2010.
I have the following list :
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
List
Currency
Status
Apple
AUD
V
Apple
AUD
V
Apple
AUD
V
Pear
AUD
V
Pear
AUD
C
Durian...
Good Day Excel MVPs and Experts.
Please advise.
I want to automatically populate in any order the results in Table 1 based on data inputs table.
I also want to have a button to click for the results in table 1 to "repopulate" again and again.
Can anybody help me?
Thanks in advance...
Hello world!
Please help me out with this
I have a work book which has 2 sheets named "Apple" And "Mango"
Sheet Apple cell A7 = Sheet Mango A1 example =Mango!A1
on Sheet Mango A1 it has a drop downlist and has many items
I have a macro to go to the next item in the list which is named as...
Hi,
How do I add sequential numbering in excel?
Say I have below data
Cell A1 Mango
Cell A2 Apple
Cell A3 Orange
Cell A4 Banana
and I would like it to be like below which is a function in MS Word
Cell A1 1. Mango
Cell A2 2. Apple
Cell A3 3. Orange
Cell A4 4. Banana
I don't want to use...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.