Forum

SunnyKow
@sunnykow
Noble Member
Joined: Jun 25, 2016
Topics: 0 / Replies: 1417
Reply
RE: Excel function for a spreadsheet

Hi Stefi I suggest in future you attach a file instead of a screenshot as it will give us a clearer picture (and it save us a lot of time from re-k...

6 years ago
Reply
RE: Formula for excel

Hi Aye Can't download your attachment. Getting a 400 Bad Request error. Can you upload the file again?

6 years ago
Reply
RE: Automatic fill required cells

Hi Rashid In cell F12 enter =IF($E$7-SUM($F$11:F11)>E12,E12,MIN($E$7-SUM($F$11:F11))) Copy down as many rows as needed. Hope this helps...

6 years ago
Reply
RE: Question related to Excel Formulae

Hi Khushboo Gaurav Q1 - Use a custom format for the cell Q2 - Use Index/Match Please refer attachment. Hope this helps. Sunny

6 years ago
Reply
RE: Matching payments and invoiced amounts

Hi Robert You can refer here to see if it helps. Sunny

6 years ago
Reply
RE: data cleansing

Hi Aye You could try this but like Philip said above, it is best if the problem could be resolved at the source. Sunny

6 years ago
Reply
RE: Please help with IF formula

Hi Mike I suggest you use VLOOKUP. Sunny

6 years ago
Reply
RE: paste formula verticaly

If you need a macro then maybe you can try this. Just make sure that there is nothing under the data. The number of rows in your data must be consi...

6 years ago
Reply
6 years ago
Forum
Reply
RE: paste formula verticaly

At least now with your attachment we can see what you actually wanted. I am not aware of any way that the formula can become B1, C1 etc when A1 is ...

6 years ago
Reply
RE: Need a help with vba script

OK now I understand why you wanted so many SKU. In this case using a userform is not recommended. Please refer attached. You only need to enter/...

6 years ago
Forum
Reply
RE: merging files into one sheet

Hi Saliha You can give this Add-In a try. Good luck Sunny

6 years ago
Reply
RE: paste formula verticaly

Hi David You could copy the required column and then use Paste - Paste Special - Transpose to do it column by column. If you require a formula t...

6 years ago
Reply
RE: Need a help with vba script

Furthermore I am wondering why you want a user form to do the searches. You could have easily done it using Data Validation (DV) and VLOOKUP in anot...

6 years ago
Forum
Reply
RE: Need a help with vba script

Other than the 10 SKU that you need to see at once, is the file that I gave you working properly?

6 years ago
Forum
Page 23 / 95