fred

If I have a table like this, that's like an audit table of dates users run reports. Report User Date Fin Fred 1/2/2018 Fin Fred 2/2/2018 Fin John 1/2/2018 HR Fred 3/2/2018 HR Fred 4/2/2018 HR Steve 4/2/2018 HR...

Hello all, First, my apologies if this question already exists. I have looked, but haven't found my particular problem discussed. Current raw data: JOE RED 10 MAY 2001 JOE BLUE 10 JUN 2001 JOE GREEN 10 JUL 2001 FRANK RED 10 JUN 2001 FRANK GREEN...

I need help with a formula to count unique values in one column that match data in another column but using a wildcard. Column A has multiple names repeated in sequence and column B has data for every occurrence of a name. I want to be able to count the number of names that have Text in a cell...

I am trying to get an IF OR function to work. Can I please get the formula from someone ? My head hurts.... I have a spreadsheet - Column B has names in it - Fred, Barney, Wilma, Betty and many others, these names appear in random order down the column. In Column E I need to calculate the...

Hi there, I would like to keep some entire rows still visible when i scroll down my excel sheet and cumulate them one after one. Eg. Rows 1, 4, 7 14, etc. Thanks a lot for your help. Fred

Below is sample of what my spreadsheet may look like: <tbody> Name Tel.# PoultryReq Wght. PorkReq. Wght. BeefReq. Wght. Bacon Wght. Fred 123 Turkey 10.00 Roasting 3.00 Back 1.50 George 456 Leg 4.00 Gammon 4.00 Arnold 789 Steak 2.00 Streaky 1.00 </tbody> What I want to do is...

Hello Excel Community, I am stuck on the next part of a large code that splits my worksheet into various new sheets based on different variables. The next part of my code needs to do the following; Recognise duplicate Name in "A", i.e; Fred & Fred. Then, create a new worksheet based on a...

Hello fellow Excellers, Im new here so hello and here we go and bear with me. I have a spread sheet already with names and values. This is an example real one has (1500 names.) New List <tbody> Name Value Bill 7 Dave 9 Fred John 4 </tbody> I now have an old (yes old)...

Hi! I am trying to find a way to web scrape data from the IMF DataBase website. I want to let Excel full automatically download the Data i have already chosen by exact link and present it as a table. I have made it already work on the FRED site (St. Louis Federal Reserve Economic Data) by this...