wanted

Hello: I am having errors when trying to use sumproduct with 3 conditions: range of dates, categories & amounts. What I am doing wrong with the formulas? . Can somebody take a look at my file? I was able to use sumifs however, I wanted to know/learn why I am getting #values error when using the...

Hi there, i am having trouble making my VBA code select the cells the way i wanted it to. Here is what i wanted it to select s2.Range("B2:M3,AB2:AB3").Select at once to fill down the selection leaving the parts in middle. But my rowcount being dynamic, i have used variables and my code looks...

Hi guys, Thank you for letting me be a part of the community. I wanted to know something about PowerQuery Excel 2016. I am getting reports of my cash register in Excel and i wanted make use of the data. The problem is that the date is only in one cell above in the sheet and i can not make a...

Hey everybody, I am a student at a community college in the United States, and I have just learned the basics of PowerBI by creating PowerPivot tables. This tool is super helpful, and makes Excel much more like a database application in my opinion. I just wanted to create a post to let you...

Ex: Row 1: B1=Dom, C1=Seg, D1=Ter, E1=Quar, ………………………. Column A A3=3, A4=2, A5=3, A6=1, ………………………………… Existing Names: Dom§1§=0 Dom§2§=0 Dom§3§=6.15 Seg§1§=38.30 Seg§2§=38.34 Seg§3§=58.46 Shown in the example below Ter§1§=11.78...

Hi All, I am having a date Oct 31, 2017 11:18 PM (i am seeing in formula bar) i wanted to convert to <tbody> 31/10/2017 23:18 </tbody> Please help me

Hi Guys, So we perform studies for our clients across a range of topics. I was wondering if there was a way to add features only certain people could ever see. For instance, if I wanted to include a 'reset all' button...where the template we use would be totally blanked to be used for a new...

Hello I found the following code on another thread: Sub Delete_Last_10_Rows() Dim rLastRow As Range Set rLastRow = Cells(Rows.Count, "C").End(xlUp) 'now delete last 10 rows: rLastRow.Offset(-9).Resize(10).EntireRow.Delete MsgBox ("The last 10 Sets of Data is now Deleted") End Sub Many...

Hello, I wanted to keep track of bills for each year in excel like the attached by month for each year but I don’t know how I can go about setting the sheets/ cells up for it.I wanted a row for bills then amount owed and its due date and a total owed and its balance. Next when I enter the paid...

Hi all, I'm looking for a macro, that when executed, would remove all cells that don't begin with one of 3 different For example, if I had these cells in column A: AA AB BC CD EA FA And I wanted to remove anything that didn't start with "A" OR "B" OR "C" I would be left with just these...

Hi all , I have one simple question in fact it's stupid too. i have loop code like below . all i wanted is the code is working fine but i wanted the code to run slowly as if we do it using F8 . like as if we doing it manually one by one i tried all the steps but could not figured it out hence...

Hi, A little help for my formula below please? I wanted to show in column E that if the actual login is equal to the person's schedule, she will be tagged as "P" or present and if he's tardy from his schedule but didnt exceed more than 5mins late, then he will still be tagged as Present. I...

So I had been trying to use vlookup to return a value from a table. My problem is that the table doesn't have constant values, there are jumps in the criteria, so vlookup is failing me. After trying to search the forums and other websites its kind of seeming like I need to use some sort of index...

Hi, I'm putting together a skills matrix in excel, the scoring is from 1 -5 however not all skills relate to each person. If I wanted to work out the average, how do I amend the formula to exclude that cell being part of the formula? =ROUND(AVERAGE(G8:G64),0) Thanks guys!

Hi All, This is more than likely not possible but thought I'd ask. Is there any way of putting a fill colour box on a userform as in the one that you would use to change a colour of a cell manually (or any alternative). I have done a userform that lets users to add options to a sheet with a...