Hi,
I am struggling to create a formula that returns a singular count for data sets over 2 columns (that are multiple columns away from each other).
I want the formula to count something only if:
It is only counting any number in Column A once.
It is also only counting the unique number in...
Hi all,
I am looking to create a formula that will look up a list of employees and check to see if they have had any sickness incidents within a month. This will then show eligible or ineligible for their name.
I have tried various IF and VLOOKUP methods, and that is where my knowledge ends...
Hey guys, bit of a tricky one here and would love some help, will try explain as well as i can.
In the cells below i have A1-C3,
A1 tells me if the action has been completed, No means it hasn't and so no.
B1 tells me the device used
C3 tells me the product
The formula i am after will...
Hey guys, Struggling here with a big project of mine and really need some help!
So the data i get in has two columns, a and b. In a it provides me with two answers either yes or no. This tells me if this was planted or not.
Column b provides me with my trees data tag. i need to find a way to...
Hi All,
I have a data table where we have Roles (varies) that people have been contacted for. Columns B:G contains the dates of the activity performed (e.g. when were they sourced, when they shared their interest so on and so forth). I need a dynamic weekly report which gives us count of all...
I'm trying to copy a couple of ranges from multiple sheets and paste them in a separate sheet in a well arranged manner.
So I should create a new sheet (we can name it PDF Template). Paste the relevant Ranges(Tables) and format/distribute them exactly as it is shown in this one:
with...
Sub Import_Text_Files()
Dim FilesToOpen
Dim x As Integer
Dim wkbAll As Workbook
Dim wkbTemp As Workbook
Dim sDelimiter As String
Application.ScreenUpdating = False
sDelimiter = "|"
FilesToOpen = Application.GetOpenFilename _
(FileFilter:="Text Files...
Hi VBA Wizards,
I have been battling to get this working. The purpose of this is that our customers need to enter a particular format to order in our b2b system. We have a problem with our ERP handling the .xml so limit the customer's orders in the b2b system to 30 lines per order. We would...
Hello there,
I actually need help in a simple task of stock balance calculation but due to this task being a daily task and my input files having least 200 entries to work on for this task I am having many difficulties. Kindly help to kind of Automate this task (or at least reducing manual...
Hi,
We've got a fleet of 58 vehicles that we used to manage by registration, so for example we would get individual requests per vehicle for MOTs, servicing, breakdowns, repairs etc. Every entry is tied to an individual vehicle, so there are hundreds of entries but it's fairly straightforward...
Hi
I am trying to see is there an easy way to create a process (I think), where all the Employes have the same form to fill daily and that this information to load into a master form without having to load one form individually.
Hi All,
I am trying to achieve a simple logic. Tried to search over google and forum before asking but couldn't get anyway near.
I am currently using below formula which is working fine but need to manually delete extra rows to obtain conditions.
(In Table) =IFERROR(VLOOKUP([@[Mobile...
Hi all,
I want to know how much cell have a blue Font color within the cells that have a green background (and so on, 5 background colors and 5 Font colors).
Exemple: I have 20 cells that have a green background, from those cells how much have a blue Font?
Here are my formulas:
Background...
Hi,
This is my first post, hope get this right.
I am newish to VBA and have come up against problem (first of many no doubt). I have searched for an answer on the forums and Google but not finding one that works for me.
I need to put multiple private subs in one work sheet but am unable to run...
Good Evening all,
I have this code that a wonderful user gave me some time ago below. The code below allows me to enter a number in A1 and it will show a that number of rows between the first visible row (6) and the last (43). I am hoping there is a way to add multiple actions in this code...
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.