head

How can I convert the following JSON data to an excel table.

I can never wrap my head around why these don't work for me. :mad: If Position = Defender or Goalkeeper AND G = 0, then show 1 if not show 0 =IF(AND(OR([@Position]="*Defender*",[@Position]="Goalkeeper"),[@G]=0),1,0) Also...

Hello all How can I open a PDF file please from an Access database using a button The path would be [C:\Tmp\PDF\ & then the value in the form field called "Invoice" the value would be [12345] Still trying to get my head around Access as I only started to use it last week Any help would be...

Hi guys, I have this book I'm working on called AZ Claim Database. Randomly (does not occur every save) it will tell me this: Sooo I press continue and rename it "AZ Claim Database 2"... This isn't making much sense to me. Does anyone have any clue as to why it would do this? It's...

I have this block of cells in my spreadhseet numerous times. <colgroup><col><col></colgroup><tbody> Head Mar Wife Mar </tbody> Is there any way I can replace it with <colgroup><col><col></colgroup><tbody> Head Mar Wife </tbody> Without deleting each one individually?

Hi All, been racking my brains on this one, looked at loads of examples. I think I just do not understand the structure of combining the if and or statements as I have written it down and it makes sense to me. :laugh: Basically I am working out employer Pension contributions. The formula in my...

I would like a formula that automatically figures out what the maximum of poynomial trendline will be no matter what numbers i plug in there. I've seen a few explanations but they are all way above my head. My X axis is A1:A4. Y axis B1:B4 X Axis Y Axis <colgroup><col...

<tbody> GRN name Tuition Fee Computer Fee 25 AAAA 11000 1000 30 BBBB 10000 31 CCC 10000 1000 </tbody> <tbody> Head GRN Amount Tuition Fee 25 11000 Computer Fee 25 1000 Tuition Fee 30 10000 Tuition Fee (manually) 31 (manually) ? (Automatecally) </tbody> What...

Hi, I have an extremely tight deadline (Monday) to create a spreadsheet with 2 sheets, 1 tab with have the twitter constants and the second tab will have a button that will post what ever is in "A1" to the given twitter account from the constants on the first tab. Does anyone have something...

Hi I have been roped in to do a pool league team sheet , what I cant work out is how to add 2 points to winning teams weekly result ie team a 5 team b 2 so team a has 5 plus two for winning it should be easy but can not get head round it

Hey guys, bare with me as this is a bit complicated to explain. I basically have a document that contains a long list of subdepartments in one sheet and a long list of people info in rows in another sheet where the subdeparment is displayed to every person. My goal is to add a column beside the...

Dear Masters, My tables are too long and I have a lot of pages. When I need to print I use Print Area. The problem is: :confused: "Just the first page has the head of the table, the page 2, page 3... have just numbers without head." I need some VBA that go to he page 2 and 3 in the same sheet...